rounding off numbers

  • Thread starter Thread starter DeeElle
  • Start date Start date
D

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
 
DeeElle said:
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
Click to expand...
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
 
If you mean to roundup to the next integer

=CEILING(cell,1)

or

=CEILING(24.3,1)

will return 25
 
GB said:
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
Click to expand...

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.
 
Thanks for all the responses!! It's what I was looking for!! I really
appreciate your help!!
Have a great day!!!
DL
 
Back
Top