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