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!
--
Nick

=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



"Nick" wrote in message
...
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!
--
Nick

Try this:

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

HTH,
Elkar


"Nick" wrote:

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!
--
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
B5 is "Cascade" then the answer is $45.00, if(A1 is "Silk" and B5 is "cascade then the answer is $35.00.
--
Nick


"Nick" wrote:

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!
--
Nick

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

Hope this helps


Nick Wrote:
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
B5 is "Cascade" then the answer is $45.00, if(A1 is "Silk" and B5 is
"cascade then the answer is $35.00.
--
Nick


"Nick" wrote:

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!
--
Nick


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

--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528732