Error in my formula?

F

fivermsg

in this formula i am calculating and increase of 25 cents per full
percent increase in a range of 110%-124%, but when i get to 120%
percent this formula becomes inaccurate? what did i do wrong? the
formula starts at 4.00$ and adds .25 per/percent.

(IF(E10<1.1,0,4+INT(MOD(E10*10,1)*10)*0.25))
 
D

Dave O

Would this do it for you? It's slightly more intuitive, for not having
the INT and MOD functions.
=(IF(E10<1.1,0,4+((E10*100)-110)*0.25))
 
Top