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?

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?