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