Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
A B
7.5 8 8.2 8 9.5 10 3.7 4 7.4 7 7.7 8 Total 44 45 Please refer above example I have some figures in column "A" it shold be rounded off , done in column "B" what I want is aftrer rounding off toal increase by 1. that is before round off total 44 ,after rounding off total 45. is there any way to round off without affecting total. total sld remain unchanged |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Round it off | Excel Worksheet Functions | |||
Round then round? | Excel Discussion (Misc queries) | |||
@ROUND | Excel Worksheet Functions | |||
round up | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |