G gopi Jun 11, 2008 #1 How to convert this type of numbers in one formula 1145 =>1150 1141 =>1150 1149 =>1150 12458=>12460
J joeu2004 Jun 11, 2008 #2 How to convert this type of numbers in one formula 1145 =>1150 1141 =>1150 1149 =>1150 12458=>12460 Click to expand... Perhaps ROUNDUP(A1,-1), where A1 contains the number. But note that 1140.0001 will round up to 1150. Is that acceptable?
How to convert this type of numbers in one formula 1145 =>1150 1141 =>1150 1149 =>1150 12458=>12460 Click to expand... Perhaps ROUNDUP(A1,-1), where A1 contains the number. But note that 1140.0001 will round up to 1150. Is that acceptable?
S Sandy Mann Jun 11, 2008 #3 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
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
