rounding off numbers

[DeeElle]

Hi everyone!
I was just wondering if it's possible to change the parameters of the
'rounding off' function to round up to the next number if the number is
something like 24.3 instead of 24.5? Is that possible?
Thanks so much for any help!!!
DL

 

[GB]

Hi everyone!
I was just wondering if it's possible to change the parameters of the
'rounding off' function to round up to the next number if the number is
something like 24.3 instead of 24.5? Is that possible?
Thanks so much for any help!!!
DL

It can be done - but why you would want to do it is a mystery. Just add 0.2
to the number you want to round and then use your current rounding formula

Geoff

 

[Peo Sjoblom]

If you mean to roundup to the next integer

=CEILING(cell,1)

or

=CEILING(24.3,1)

will return 25

 

[Alan]

It can be done - but why you would want to do it is a mystery.
Just add 0.2
to the number you want to round and then use your current
rounding formula

Geoff

That might not work though.

What if the value was 24.9?

If you are using ROUNDUP(24.9,0) you would get 25, but
ROUNDUP(24.9+0.2,0) gives 26.

Is that what the OP wanted? If so, then no problem.

Alan.

 

[DeeElle]

Thanks for all the responses!! It's what I was looking for!! I really
appreciate your help!!
Have a great day!!!
DL