Round numbers in no of digits

[gopi]

How to convert this type of numbers in one formula
1145 =>1150
1141 =>1150
1149 =>1150
12458=>12460

 

[joeu2004]

How to convert this type of numbers in one formula
                1145 =>1150
                1141 =>1150
                1149 =>1150
                12458=>12460

Perhaps ROUNDUP(A1,-1), where A1 contains the number.

But note that 1140.0001 will round up to 1150. Is that acceptable?

 

[Dave Curtis]

Hi,

If your number is in, say A1, try

=ROUNDUP(A1,-1)

This should round your number up to the next "ten"

Dave

url:http://www.ureader.com/msg/10355850.aspx

 

[Sandy Mann]

Just another option:

=CEILING(A1,10)

--
HTH

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

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