Conditional Formulas

N

Nick

I can't figure out the formula for the following: If cell (A1 is "Fresh" and
B5 is "Cascade" then the answer is $45.00. Can anyone help!
 
P

Peo Sjoblom

=IF(AND(A1="Fresh",B5="Cascade"),45,0)

replace fresh and cascade in the formula with 2 other cell references where
in you can type the criteria
I put 0 if this was FALSE


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
N

Nick

Thanks for the help. Now my second question is this. How would I add the
same formula multiple times in the same cell? i.e (A1 is "Fresh" and
 
D

Door

Perhaps the limitation of the If statement will not allow you sufficien
options, you may need to Match from a Table as per the attached.

Hope this helps

Thanks for the help. Now my second question is this. How would I ad
the
same formula multiple times in the same cell? i.e (A1 is "Fresh" and
"cascade then the answer is $35.00.
Click to expand...

+-------------------------------------------------------------------
|Filename: Match.zip
|Download: http://www.excelforum.com/attachment.php?postid=4558
+-------------------------------------------------------------------
 
Top