I have created a formula: =IF(G10="N","=M10",IF(G10="Y","=.95*M10")) to
adjust a salary dependent on whether salary savings have been taken (Y) or
not (N). If they have been, then I want to multiply the previous cell by .95
to adjust the salary. The formula works to the point where if G10 has Y,
then =M10 shows up in the cell, and if G10 has N, then =.95*M10 shows up in
the cell. But I want those to actually calculate rather than just show the
formula. Can anyone help me?