Round numbers in no of digits
 

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

Round numbers in no of digits
 

On Jun 10, 8:26*pm, gopi wrote:
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?

Round numbers in no of digits
 

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

Round numbers in no of digits
 

Just another option:

=CEILING(A1,10)

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"gopi" wrote in message
...
How to convert this type of numbers in one formula
1145 =1150
1141 =1150
1149 =1150
12458=12460