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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ROUNDING UP 2
in access, round up to nearest fraction(.5) 1
Alternate Rounding Up & Down of .50 in a column 5
column is added up by original figure not after rounding up 1
rounding to nearest hundred dollar in Excel 7
rounding up to nearest specified whole number 1
Round number subject to it's value 1
Round up to nearest 25 or 50? 8

Back
Top