Hmmm...I can't duplicate that error. I copied the posted formula from
the screen to test it and I keep getting correct values.

Using =ROUNDUP(MIN((0.4*A1)+0.15*MIN(3500,A1),3500),0)

For A1 = 2500: I get 1375
For A1 = 3500: I get 1925
For A1 = 8333.33: I get 3500

Did you copy the formula from the screen or re-type it?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=394278