Rounding numbers

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I need a formula to round numbers up to one decimal
place to the nearest .5

So for example 4.67 would round up to 5.0 where as 4.322
would round up to 4.5.

As anybody got any ideas how I can do this one, please.

Kevin
 
Kevin,

Use

=ROUND(A1*2,0)/2

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thank you.

It works fine.

Kevin
-----Original Message-----
Kevin,

Use

=ROUND(A1*2,0)/2

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
You realize that it will round to nearest .5 not always round up.
If you need to roundup use

=CEILING(A1,0.5)
 
Peo,

Re-read the OP after your reply. Kevin actually says nearest .5 (which is
round in my book), and then later says round up!

Quelle confusion as DelBoy would say.

Regards

Bob
 
Bob,

"I need a formula to round numbers up to one decimal
place to the nearest .5"

He posts a clarificaction telling what version he is using and in that
subject line he uses "Rounding up number"

OTOH he posts back and says it works fine..

Only the OP can tell..
 
Replied before I saw that one!

Bob

Peo Sjoblom said:
Bob,

"I need a formula to round numbers up to one decimal
place to the nearest .5"

He posts a clarificaction telling what version he is using and in that
subject line he uses "Rounding up number"

OTOH he posts back and says it works fine..

Only the OP can tell..

--

Regards,

Peo Sjoblom
Click to expand...
 
Back
Top