Hi, I am working with Excel. I got a problem. In cell A1 = 3 .5 cell B1 = 3, Q is in cell C1= A1 * B1 gives me Ans: 10.5, Where as i need it as 11. Even if i multiply cell C1*6 should give me 66 not 63. Please help me !
2006-10-17 04:06:18 · 7 answers · asked by Raju 2 in Computers & Internet ➔ Programming & Design
c1=round(a1*b1)
no need to format anything (it would be a wrong thing to do anyway, because 63 would still be 63).
2006-10-17 04:26:54 · answer #1 · answered by n0body 4 · 2⤊ 0⤋
You need to go to "Format" then choose "Cells" and (in the "Number" tab) choose how many decimal places. If you choose zero decimals, it will round for you.
However, when you round C1 then multiply by 6, it will still give you 63, because it is using the "actual" value in that cell, not the "rounded" value.
2006-10-17 11:15:16 · answer #2 · answered by homeschoolmom 5 · 1⤊ 0⤋
format c1 to zero decimal places. excel will round up to 11 which will make c1*6 = 66.
2006-10-17 11:18:48 · answer #3 · answered by Magick Kitty 7 · 0⤊ 1⤋
Format the cell C1 to use no decimal places.
Rawlyn.
2006-10-17 11:20:55 · answer #4 · answered by Anonymous · 0⤊ 1⤋
Format the cell, set the type to a number and the decimal places to zero and it will round it for you.
2006-10-17 11:17:11 · answer #5 · answered by Anonymous · 0⤊ 1⤋
go to format cells and in the number tab, choose number in category and put 0 in the decimal places field.
2006-10-17 11:20:09 · answer #6 · answered by greengrapecake 2 · 0⤊ 1⤋
right click and select format cells
select number on left
make decimal places to zero
click ok
2006-10-17 11:20:22 · answer #7 · answered by Ansari 2 · 0⤊ 1⤋