excel formula
 

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?

excel formula
 

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

"asdreifus" wrote:

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?

excel formula
 

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

=IF(A135,A1*0.0625,A1*0.0725)

What do you want if A1 is exactly 35?


Gord Dibben MS Excel MVP

On Thu, 14 Aug 2008 12:48:16 -0700, asdreifus
wrote:

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?