IF and formula NOT COMPLETE

W

Wanna Learn

Hello
Excel 2003 Scenario
I have 2 reports
This is what I ‘m trying to do

IF cell C60 = C78 in the second report AND if cell J60 = J78 in the second
report then AA78 from the second report

THis is what I have but don’t know how to finish the formula
=IF(C60=[SalesOrderDec909.xls]December09!$C$78,[SalesOrderDec909.xls]December09!$AA$78)
thanks
 
F

FrankWood

Try this and see if it does what you are looking for.

=IF(C60=[SalesOrderDec909.xls]December09!$C$78,IF(J60=[SalesOrderDec909.xls]December09!$AA$78,[SalesOrderDec909.xls]December09!$AA$78,"C60
is equal but J60 is Not equal"),"C60 is Not Equal")

Hope it helps,

Frank
 
E

Eduardo

Hi,
If you are looking for both conditions to be met use

=IF(and(C60=[SalesOrderDec909.xls]December09!$C$78,J60=[SalesOrderDec909.xls]December09!$J$78),[SalesOrderDec909.xls]December09!$AA$78,"")

I add the variable "" to leave blank if the conditon is not met
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top