| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Down Formula
I have the following formula: =sum(J24/S24). The answer is 22.25%. Once
I've decreased the number of decimals to 1, I need it to read 22.2%. How do I do this? Thanks!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Down Formula
To start with, why have you used SUM()? What numbers are you trying to add?
If you are dividing, then the formula is =J24/S24. If you want to round down, rather than round to the nearest, then =ROUNDDOWN(J24/S24,3) -- David Biddulph "Lilbit" wrote in message lkaboutsoftware.com... I have the following formula: =sum(J24/S24). The answer is 22.25%. Once I've decreased the number of decimals to 1, I need it to read 22.2%. How do I do this? Thanks!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Down Formula
Perfect!! Thanks ever so much!!!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding Formula | Excel Worksheet Functions | |||
| Rounding up Formula | Excel Worksheet Functions | |||
| rounding a formula with sum | Excel Discussion (Misc queries) | |||
| Rounding with the sum formula | Excel Discussion (Misc queries) | |||
| rounding formula | Excel Worksheet Functions | |||
Linear Mode
