 # Round Up To Nearest X`

• 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

## Files

• Re: Round Up To Nearest X`

Interesting, Jim, thanks. Hope the OP notices.

[SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

• Re: Round Up To Nearest X`

Quote from JimFuller1

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

Let the OP to decide which one is correct.

BTW, to match your results, try

=CEILING(B2,50)-5

HTH

• 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

[SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

• 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.

[SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

• Re: Round Up To Nearest X`

Quote from datzneat

Kris's is doing exactly what i want. Looks like the others aren't. Thanks for noticing that Jim.

OK. that's fine.

Keep EXCELing

• 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

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!