# Divide a number by a different percentage depending on value

• How do I write the below formula:

If j2 is >=3400 then divide I2 by 1%, if j2 is >=3200 and <3400 then divide I2 by 0.85%, if j2 is >=2800 <3200 then divide I2 by 0.65%, if j2 is >=2300 and <2800 then divide I2 by 0.50%, if <=2300 then divide by 0.40%

So in this example the answer is 1488.79

• Re: diivde a number by a different percentage depending on value

try this

=IF(J2>=3400,J2/0.01,IF(AND(J2>=3200,J2<3400),J2/0.85,IF(AND(J2>=2800,J2<3200),J2/0.65,IF(AND(J2>=2300,J2<2800),J2/0.5,J2/0.4))))

• Re: diivde a number by a different percentage depending on value

it doesnt work.

the formula doesnt mention cell "I2"

i have attached the spreadsheet to see if that help.

## Files

• Re: diivde a number by a different percentage depending on value

done it now thanks anyway

• Re: diivde a number by a different percentage depending on value

=i2/lookup(j2,{0,2300,2800,3200,3400},{0.4,0.5,0.65,0.85,0.01})

[COLOR="blue"][SIZE="4"][FONT="Verdana"]AAE[/FONT][/SIZE][/COLOR]
[COLOR="blue"]----------------------------------------------------[/COLOR]

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!