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="A";A2*0,5;IF(A1="B";A2*0,55;IF(A1="C";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: http://www.excelforum.com/member.php...o&userid=19846
View this thread: http://www.excelforum.com/showthread...hreadid=541960

I am trying to create a formula. If discount code is A multiply by .5
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,{"A",0.5;"B",0.55;"C",0.88})
Adjust for your specific discount list.

hi!

in C1: =IF(B1="A",(A1*0.5),(A1*0.55))

where COL A having the amount
COL B having the discount code (either "A" or "B")

-via135

Dave Wrote:
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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=541960

I tried this and it doesn't seem to work
--
Dave1125


"B4MB4M" wrote:


maybe something like this :

A1 = discount code
A2 = money value
=IF(A1="A";A2*0,5;IF(A1="B";A2*0,55;IF(A1="C";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: http://www.excelforum.com/member.php...o&userid=19846
View this thread: http://www.excelforum.com/showthread...hreadid=541960