G Guest Jul 15, 2004 #1 I'd like to round a number for example 1,234,567 to 1,235 million. How do I do that as a function in Excel?
I'd like to round a number for example 1,234,567 to 1,235 million. How do I do that as a function in Excel?
J Jacques Brun Jul 15, 2004 #2 use the round function =round(A1,3) where A1 is the cell containing your number and 3 is the number of decimals you want to show if A1=1.234567 the result of above function will be 1.235 Note that the number of decimals can be 0 to obtain a whole number: round(12.5,0) ==> 13 or even negative to obtain multiple of 10, 100, 1000 etc... round(125,-2) ==> 100 round(6543,-3) ==> 7000 -----Original Message----- I'd like to round a number for example 1,234,567 to 1,235 Click to expand... million. How do I do that as a function in Excel?
use the round function =round(A1,3) where A1 is the cell containing your number and 3 is the number of decimals you want to show if A1=1.234567 the result of above function will be 1.235 Note that the number of decimals can be 0 to obtain a whole number: round(12.5,0) ==> 13 or even negative to obtain multiple of 10, 100, 1000 etc... round(125,-2) ==> 100 round(6543,-3) ==> 7000 -----Original Message----- I'd like to round a number for example 1,234,567 to 1,235 Click to expand... million. How do I do that as a function in Excel?
