conditional formula
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? |
On Thu, 22 Sep 2005 08:38:07 -0700, "Kari"
wrote: 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 __________________________ |
All times are GMT +1. The time now is 09:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com