| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Divide and round
if any one can help
e.g i have $100 in A1 and like to divide it by 12 and round the figure to 3 decimal place and put the result in B1 to M1 and then total of (B1:M1)in N1 the result is $99.996 how can i make it $100 without manually changing the figures in B1:M1 Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format divide by 10 / single digit view: Custom? Text(Round( | Excel Discussion (Misc queries) | |||
| divide by zero | Excel Worksheet Functions | |||
| Divide by Zero | Excel Worksheet Functions | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Threaded Mode
