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
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!