Re: Round Up To Nearest 45 Or 95
Yep. Exactly what i wanted.
Re: Round Up To Nearest 45 Or 95
Yep. Exactly what i wanted.
Re: Round Up To Nearest X`
I ran a comparison of the three formulas for what it's worth. There are some differences between Krish's and the other two.
Jim
Re: Round Up To Nearest X`
Interesting, Jim, thanks. Hope the OP notices.
Re: Round Up To Nearest X`
Don't think so, Kris:
CEILING(46,50)-5 = 45
=IF( (46-(ROUNDDOWN(46,-2)+95)) > (46-(ROUNDDOWN(46,-2)+45)), (ROUNDDOWN(46,-2)+45), IF( (46-(ROUNDDOWN(46,-2)+45)) < 0, (ROUNDDOWN(46,-2)+45), (ROUNDDOWN(46,-2)+95) )) = 95
=46 - MOD( 46, 100) + IF( MOD( 46, 100) > 45, 95, 45 ) = 95
Re: Round Up To Nearest X`
Kris's is doing exactly what i want. Looks like the others aren't. Thanks for noticing that Jim.
Re: Round Up To Nearest X`
Cool. Good job, Kris.
Re: Round Up To Nearest X`
Kris has an uncanny knack of interpreting users needs.
Re: Round Up To Nearest X`
A Krish formula in the hand is worth 10 of mine in the bush any day I always say.
:smile: Jim
Don’t have an account yet? Register yourself now and be a part of our community!