Jun 10, 2013
I amlooking at the number 308,499,000 and I want to
IF INT([Number]/[Parameter Any])*[Parameter Any] = [Number] THEN [Number]; ELSEIF SIGN([Number]) = -1 THEN INT([Number]/[Parameter ...
If the digit in the hundred thousand's place in a number is 0, 1, 2, 3 or 4 then
To round the numbers to Millions we can use Custom Format and Round function
in Excel. We can
6,852,783. rounded to the nearest hundred is, 6,852,800. 6,852,783 rounded to
the nearest thousand is, 6,853,000. 6,852,783