Using the IF function for various discount cost.

[Phil Walters]

Hi all

i am looking at automatically working out the final discount cost price of individual products with varying levels of % discount. i am assuming that this would use the IF function and is very straight forward.

can you help. i have added the spreadsheet were column C is the current net price and column D contains the discount code and finally column E would contain the new discount cost. i have added the table where the code has its representative discount value.

Thank you very much in advance

Phil

[Søren Larsen]

in E2:

C2*(1-SUMPRODUCT((D2=$I$5:$I$15)*1,$J$5:$J$15)/100)

And copy down.

You should change "NET" in J15 to 0, otherwise items with discount code K will return an error.

[Phil Walters]

Hi soren

Thanks but i am cleary missing something. when i copy it in it just copies the formula and does nothing with it.

[Søren Larsen]

Hi soren

Thanks but i am cleary missing something. when i copy it in it just copies the formula and does nothing with it.

I forgot an "=", see if it works now:

=C2*(1-SUMPRODUCT((D2=$I$5:$I$15)*1,$J$5:$J$15)/100)

If it does not, then try switching the "," with a ";".

[Phil Walters]

Excellent work Soren

Works a treat

Thank you very much

Phil