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