=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