excel formula

  • Thread starter Thread starter asdreifus
  • Start date Start date
A

asdreifus

I need a formula that allows for two different percentages based on reaching
a certain limit. I tried the following:

=IF(cell#>35,cell#*.0625),If(cell#<35,cell#*.0725)

I got the VALUE# error message. Any ideas?
 
Try this,

=IF(A1<35,A1*0.0725,A1*0.0625)

Note that this will multiply 35 * 0.0625. If you want to force it the other
way try

=IF(A1<=35,A1*0.0725,A1*0.0625)

Mike
 
If those are the only two choices................

=IF(A1>35,A1*0.0625,A1*0.0725)

What do you want if A1 is exactly 35?


Gord Dibben MS Excel MVP
 
Back
Top