Formula to get another result if cell is blank

[mack4n]

Hi all,

Need a formula for my price list. Lets say that the costumer has a discount of 10% on all products. I would like to give the costumer a special discount (lets say 20%) on some specific product(s). If no special discount is given, I would like the standard discounted price to be listed in "Final price" column and not the ordinary price.

To be clear: If column E is set to 0 or blank, I would like the discounted price in column D to be listed in column F (final price) instead of the ordinary price in column C.

Is this possible?

Please see attached.

[gmr4evr1]

Try this in F3 of your sample

Please Login or Register  to view this content.

[sandy666]

try:
=IF(OR(E2="",E2=0),D2,(C2-C2*E2/100))

[mack4n]

I tried to add the formulas above but unfortunately I got an error code on both.

[sandy666]

worksheet-1_ans.xlsx

[mack4n]

Attachment 388979

Ohh my.. Forgot to translate it. Thank you sandy!

[sandy666]

you are welcome