Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i round up an answer in a cell that has a formula attached?
I have copied a number from another worsheet onto a cell (G-5) on another
spreadsheet then typed a formula into a cell B5=G5/210 but the answer differs from that as when i work it out on a calculator. I think the reason is the decimal places that i have brought in from the other worksheet, but if i check the number of decimal places, it is already set at 2 decimal places. This is giving us a nightmare on an accounting system that we have which differs in the final answer to the spreadsheet that we have. Can anybody help me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i round up an answer in a cell that has a formulaattached?
Put this formula in B5:
=ROUND(G5/210,2) If the cell is set with a format of 2 decimal places, this affects the display of the number, not its value. Hope this helps. Pete On Oct 21, 12:08*am, Monsta1266 wrote: I have copied a number from another worsheet onto a cell (G-5) on another spreadsheet then typed a formula into a cell B5=G5/210 but the answer differs from that as when i work it out on a calculator. I think the reason is the decimal places that i have brought in from the other worksheet, but if i check the number of decimal places, it is already set at 2 decimal places.. This is giving us a nightmare on an accounting system that we have which differs in the final answer to the spreadsheet that we have. Can anybody help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula changes to answer within the cell or some variation | Excel Worksheet Functions | |||
How do I round up the answer an iferror formula? | Excel Discussion (Misc queries) | |||
Formula in a cell, keep the answer from going over a certain value | Excel Discussion (Misc queries) | |||
Update Excel cell in formula not refreshing answer cell | Excel Discussion (Misc queries) | |||
Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) |