Rounding numbers

[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

 

[Bob Phillips]

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)

 

[kevin.billson]

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)




.

 

[Peo Sjoblom]

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

=CEILING(A1,0.5)

 

[Bob Phillips]

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

 

[Peo Sjoblom]

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..

 

[Bob Phillips]

Replied before I saw that one!

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..

--

Regards,

Peo Sjoblom