Ok let's say I put 0.45 in A1 and filled series down with adding 0.45 each time. I then put the cells to 0 decimal places. So the number has rounded up or down accordingly. In cell B1 I use the formula =SUM(A1:A200). It uses the 0.45, 0.9 etc... how can I get it to use the whole number instead?
2006-10-07 10:24:08 · 3 answers · asked by steff 2 in Computers & Internet ➔ Software
You would need to tweak the formula.
MS Excel uses what you enter as the value. So, A1 = 0.45. Even though you set the cell to display no decimal places, they are still there. So, in the formula, you will have to use the INT value on A1
2006-10-07 10:33:07 · answer #1 · answered by cyrenaica 6 · 1⤊ 0⤋
that's exciting to quit and imagine about the certainly length of a worksheet. Do the mathematics (256 * sixty 5,536), and we are able to work out that a worksheet has 16,777,216 cells. keep in mind, that is in only one worksheet. A unmarried workbook can carry more suitable than one worksheet. If we are using the classic VGA video mode with the default row heights and column widths, we may be able to work out 9 columns and 18 rows (or 162 cells) at a time. If we entered a unmarried digit into each and every cellular at a truly speedy clip of one cellular in preserving with 2d, it might want to take us about 194 days, non-quit, to suitable off a worksheet (longer, if our destroy for espresso). To print the outcome of our efforts might want to require more suitable than 36,000 sheets of paper - a stack about six ft tall Oh... and if you're wondering: No, it isn't accessible to develop the size of a worksheet. The type of rows and columns is fastened. even with what ought to volume to thousands of requests to Microsoft, we in simple terms can not coax Excel into exhibiting extra rows or column.
2016-12-04 09:25:51 · answer #2 · answered by ? 4 · 0⤊ 0⤋
You can round the result. Excel always uses the true value of the cell.
=ROUND(SUM(A1:A200))
2006-10-07 10:38:29 · answer #3 · answered by read c 2 · 0⤊ 0⤋