-
All replies
-
Helpful answers
-
Mar 19, 2014 11:45 PM in response to KW2014by Barry,If these are the only two possible values, a simple IF statement will do the job:
=IF(G2="MD",K2*0.92,K2*0.95)
If other values (including an empty cell) are possible for G2, then a nested pair of IFs is needed:
=IF(G2="MD",K2*0.92,IF(G2="DC",K2*0.95,"-"))
This version will do the correct multiplication for each of the two permitted values in G2. For any other value in G2, the formul will place the text value "-" in its cell.
Regards,
Barry