I thought I might help someone with a problem they were having:
"Modified Rounding
I need a formula that will round a value based on whether it is less than or equal to .25. So, for instance, 3.24 would round down to 3 and 3.25 (or greater) would round up to 4."
So I wrote the formula =IF(MOD(B2,1)>0.24,ROUNDUP(B2,0),ROUNDDOWN(B2,0)) and tested it and it worked fine until it had to deal with numbers between 32.24 and 44.24 where it rounds up instead of down! I was wondering if anyone could tell me if I've missed something (likely) or is it a problem with Excel (less likely)!
Thanks very much.
Paul.