Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
IF and formula NOT COMPLETE
0 views
Skip to first unread message
Wanna Learn
Dec 10, 2009, 8:34:06 AM12/10/09
to
Hello
Excel 2003 Scenario
I have 2 reports
This is what I ‘m trying to do
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
FrankWood
Dec 10, 2009, 11:25:01 AM12/10/09
to
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
Eduardo
Dec 11, 2009, 9:14:03 AM12/11/09
to
Hi,
If you are looking for both conditions to be met use
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
0 new messages