Error in my formula?
 

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))


--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=522284

Error in my formula?
 

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))

Error in my formula?
 

i had to throw an =int into it but it worked.. thanks


--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=522284