Rounding

[Grant]

How can I round 58 up to 60?

 

[Guest]

=ROUND(C19/10,0)*10

where C19 contains the value 58

 

[JE McGimpsey]

One way:

=ROUND(58,-1)

Another:

=ROUNDUP(58,-1)

Another:

=CEILING(58,10)

 

[Sandy Mann]

Just another way:

=CEILING(C19,10)

--
HTH

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk