Round up to next half number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to round up a number to what I recall from school days to be
"correct to the nearest half". In other words, if the cell value is between
3.01 and 3.49 I want to round it to 3.5. If the cell value is 3.5 to 3.99 I
want it rounded to 4.0

I have managed to round up and down to the nearest whole number but can't
figure out how to get it to the nearest half! Can anyone help, please?
RMB
 
You don't really want 3.5 to become 4 do you?

perhaps, if you only have positive numbers

=CEILING(A1,0.5
 
daddylonglegs,

Yes I did want 3.5 to become 4 - but thanks for the formula anyway - I've
never used "Ceiling" before! I'll have to read up on it!

RMB
 
For positive numbers

=ROUNDUP(A1*2,0)/2

does the same as

=CEILING(A1,0.5)

neither of them will return 4 when A1 is equal to 3.5, what result d
you want when A1 is 3
 
Daddylonglegs,

Thanks for that! Actually you were right when you said I wouldn't want 3.5
rounded up so what I need is if the result is 3, then I want it to stay as 3.
Result of 3.01 to 3.5 to be 3.5 and 3.51 to 4 to be 4.

Your suggestion and that of Bernard's both do that so thanks again!

RMB
 
Back
Top