software

I am trying to create a formula. If discount code is A multiply by .5
if dsicount code is B multiply by .55 excetera
Any help would be appreciated
--
Dave1125


maybe something like this :

A1 = discount code
A2 = money value
=IF(A1=quot;Aquot;;A2*0,5;IF(A1=quot;Bquot;;A2*0,55;IF(A1=quot;Cquot;;A2*0 ,6;A2*0,65)))

if you need more discount codes...just add them to the end of the line

Regards
B4M--
B4MB4M
------------------------------------------------------------------------
B4MB4M's Profile: www.excelforum.com/member.php...oamp;userid=19846
View this thread: www.excelforum.com/showthread...hreadid=541960gt; I am trying to create a formula. If discount code is A multiply by .5
gt; if discount code is B multiply by .55 etcetera

One way...

If an amount is in A1 and a letter is in B1, put this in C1:
=A1*LOOKUP(B1,{quot;Aquot;,0.5;quot;Bquot;,0.55;quot;Cquot;,0.88})
Adjust for your specific discount list.


hi!

in C1: =IF(B1=quot;Aquot;,(A1*0.5),(A1*0.55))

where COL A having the amount
COL B having the discount code (either quot;Aquot; or quot;Bquot;)

-via135

Dave Wrote:
gt; I am trying to create a formula. If discount code is A multiply by .5
gt; if dsicount code is B multiply by .55 excetera
gt; Any help would be appreciated
gt; --
gt; Dave1125--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=541960I tried this and it doesn't seem to work
--
Dave1125quot;B4MB4Mquot; wrote:

gt;
gt; maybe something like this :
gt;
gt; A1 = discount code
gt; A2 = money value
gt; =IF(A1=quot;Aquot;;A2*0,5;IF(A1=quot;Bquot;;A2*0,55;IF(A1=quot;Cquot;;A2*0 ,6;A2*0,65)))
gt;
gt; if you need more discount codes...just add them to the end of the line
gt;
gt; Regards
gt; B4M
gt;
gt;
gt; --
gt; B4MB4M
gt; ------------------------------------------------------------------------
gt; B4MB4M's Profile: www.excelforum.com/member.php...oamp;userid=19846
gt; View this thread: www.excelforum.com/showthread...hreadid=541960
gt;
gt;