| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dividing linked cells
I have to get the total of a list of cells that have been linked and is
rounding the number. I am dividing cells =c47/c48 which is 8831/33 and I get on C49=270 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dividing linked cells
Display the cells with 2 or more decimal places and I expect you will find
the data is not 8831 or 33 but something like 8831.51 and 32.73 =8831.49/32.7 will give an answer of 270 (270.08 to 2 decimal places) but show as 8831 and 33 with no decimal places. HTH "Ana G" wrote: I have to get the total of a list of cells that have been linked and is rounding the number. I am dividing cells =c47/c48 which is 8831/33 and I get on C49=270 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| Linked cells and text boxes | Excel Discussion (Misc queries) | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Show cells have been read - linked | Excel Discussion (Misc queries) | |||
Linear Mode
