software

I can't figure out the formula for the following: If cell (A1 is quot;Freshquot; and
B5 is quot;Cascadequot; then the answer is $45.00. Can anyone help!
--
Nick

=IF(AND(A1=quot;Freshquot;,B5=quot;Cascadequot;),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

nwexcelsolutions.com
quot;Nickquot; gt; wrote in message
...
gt;I can't figure out the formula for the following: If cell (A1 is quot;Freshquot;
gt;and
gt; B5 is quot;Cascadequot; then the answer is $45.00. Can anyone help!
gt; --
gt; Nick
Try this:

=IF(AND(A1=quot;Freshquot;,B5=quot;Cascadequot;),45,quot;quot;)

HTH,
Elkarquot;Nickquot; wrote:

gt; I can't figure out the formula for the following: If cell (A1 is quot;Freshquot; and
gt; B5 is quot;Cascadequot; then the answer is $45.00. Can anyone help!
gt; --
gt; 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 quot;Freshquot; and
gt; B5 is quot;Cascadequot; then the answer is $45.00, if(A1 is quot;Silkquot; and B5 is quot;cascade then the answer is $35.00.
--
Nickquot;Nickquot; wrote:

gt; I can't figure out the formula for the following: If cell (A1 is quot;Freshquot; and
gt; B5 is quot;Cascadequot; then the answer is $45.00. Can anyone help!
gt; --
gt; 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 helpsNick Wrote:
gt; Thanks for the help. Now my second question is this. How would I add
gt; the
gt; same formula multiple times in the same cell? i.e (A1 is quot;Freshquot; and
gt; gt; B5 is quot;Cascadequot; then the answer is $45.00, if(A1 is quot;Silkquot; and B5 is
gt; quot;cascade then the answer is $35.00.
gt; --
gt; Nick
gt;
gt;
gt; quot;Nickquot; wrote:
gt;
gt; gt; I can't figure out the formula for the following: If cell (A1 is
gt; quot;Freshquot; and
gt; gt; B5 is quot;Cascadequot; then the answer is $45.00. Can anyone help!
gt; gt; --
gt; gt; Nick -------------------------------------------------------------------
|Filename: Match.zip |
|Download: www.excelforum.com/attachment.php?postid=4558 |
-------------------------------------------------------------------

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