Conditional Formulas

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" <Nick@discussions.microsoft.com> wrote in message
news:3BCD98C0-902A-4686-B4BD-F91A01D521A8@microsoft.com...
>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

Originally Posted by 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