If, Then, Or formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top