Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting formula not acceptable? | Excel Discussion (Misc queries) | |||
Using a Formula in a Conditional Statement? | Excel Worksheet Functions | |||
How to combine conditional format with formula ? | Excel Worksheet Functions | |||
conditional formatting formula | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |