I want to get a rounded-off value when working in Excel with formulas. However, I don't only want the numbers after the decimal points gone, but I also want the last two digits of the numbers to be 0 as well. For example: 15 444 - 15 400. Is this even possible in Excel? If yes, how do I do it?
Thank you for your answers!
2006-07-10 23:38:00 · 3 answers · asked by Zelda_of_Arel 2 in Computers & Internet ➔ Software
use the formula
round(cell, -2)
2006-07-10 23:41:33 · answer #1 · answered by Anonymous · 0⤊ 0⤋
you do not say what values that is occurring at yet i wager it is going to be great values of n. Excel has obstacles, take a seem for articles in the Microsoft awareness base. Excel is constrained to numbers numbers in the decision of about 10^(-308) and 10^308. There also are problems with storing very small numbers as intermediate leads to calculations and some blunders should be presented. the awareness base does make exciting studying and delivers you an perception into the themes enthusiastic about appearing calculations with very great or very small numbers and one in all those blunders that ought to nicely be presented with some fairly lifelike looking numbers. some numbers that seem constructive and straightforward to the bottom 10 outcome in repeating, not in any respect ending sorts in binary which in the right circumstances can produce blunders that you ought to no longer oftentimes imagine of.
2016-10-14 08:33:10 · answer #2 · answered by ? 4 · 0⤊ 0⤋
use the function "ROUND"
e.g. "=ROUND(15444;-2)
2006-07-10 23:52:42 · answer #3 · answered by Anonymous · 0⤊ 0⤋