conditional formula

[Guest]

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?

 

[Richard Buttrey]

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?

You just need to take out the quotes which are causing the result to
be a string rather than a value

=IF(G10="N",M10,IF(G10="Y",0.95*M10,))

If G10 can only ever be Y or N you could simplify further

=IF(G10="N",M10,0.95*M10)

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________