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
>
>