ExcelBanter - Rounding

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding (https://www.excelbanter.com/excel-worksheet-functions/132993-rounding.html)

Grant

Rounding

How can I round 58 up to 60?

Duke Carey

Rounding

=ROUND(C19/10,0)*10

where C19 contains the value 58

"Grant" wrote:

How can I round 58 up to 60?

JE McGimpsey

Rounding

One way:

=ROUND(58,-1)

Another:

=ROUNDUP(58,-1)

Another:

=CEILING(58,10)

In article ,
"Grant" wrote:

How can I round 58 up to 60?

Sandy Mann

Rounding

Just another way:

=CEILING(C19,10)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

with @tiscali.co.uk

"Grant" wrote in message
...
How can I round 58 up to 60?

All times are GMT +1. The time now is 12:24 PM.