G
gopi
How to convert this type of numbers in one formula
1145 =>1150
1141 =>1150
1149 =>1150
12458=>12460
1145 =>1150
1141 =>1150
1149 =>1150
12458=>12460
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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?
D
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
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
S
Sandy Mann
Just another option:
=CEILING(A1,10)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk
=CEILING(A1,10)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk