Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell subtraction problem
I want to subtract a percent sum from a cell but must have three choices.
Example if cell is under 25 then subtract 8 percent if over 25 then subtract 9 percent if over 70 then subtract 10 percent. Can anyone tell me a formula for this or if it is even possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell subtraction problem
Assuming the cell is A1
=iF(A1<25,a1*92%,if(A1<=70,A1*91%,A1*90%)) btw: this is not a programming question (programming is VBA) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "prefector" wrote in message ... I want to subtract a percent sum from a cell but must have three choices. Example if cell is under 25 then subtract 8 percent if over 25 then subtract 9 percent if over 70 then subtract 10 percent. Can anyone tell me a formula for this or if it is even possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Adding/Subtraction and format of cell. - HELP!!! | Excel Worksheet Functions | |||
easy (?) subtraction problem | Excel Programming | |||
How to make a null cell as 0 (Zero) so that the subtraction works | Excel Worksheet Functions | |||
Cell subtraction | New Users to Excel | |||
time subtraction problem | Excel Worksheet Functions |