Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If, Then, Or formating
I am trying to a variable percentage to a single cel
example: If B3 is <= to 32199 then c3 will read 0 then if B3 is =32200 but less than 38639 then c3 will read .5% and how many if's can this cell hold am I making any sense? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If, Then, Or formating
You can have up to 7 if's (more in XL2007). In C3 put:
=if(b3<=32199,0,if(b3<38639,0.5%,"something else")) Your numbers look like Excel dates. If so, your formula would be more readable if you substituted something like Date(1998,2,26) for the number. -- Regards, Fred "Scott" wrote in message ... I am trying to a variable percentage to a single cel example: If B3 is <= to 32199 then c3 will read 0 then if B3 is =32200 but less than 38639 then c3 will read .5% and how many if's can this cell hold am I making any sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating | Excel Discussion (Misc queries) | |||
formating | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Formating h:mm AM/PM | Excel Discussion (Misc queries) | |||
Formating | Excel Discussion (Misc queries) |