How to display total IF other cell value euqals 1

[tomkilbourn]

Hello,

I am displaying a total from a formula (shown below) in cell B20.

If the value of cell F26 equals 1 the calculation is shown in B20.

I want to add the following to it - If F26 equals 2 then display a message "No Discount Applied" in cell B20.

=IF(F26=1,B18-(B18*0.2),B18)


How should I do this?

[zbor]

try this:

=IF(F26=2,"No Discount Applied",IF(F26=1,B18*0.8,B18))

[tomkilbourn]

Thats it, thankyou

[zbor]

Please make thread [solved]