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? |
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) |