| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
what do i do to make ="["&J5*0.063&"]" round to the nearest whole number
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding
To ROUND a formula result to the nearest whole number, just wrap the formula
in a ROUND formula, like....... =ROUND(YourFormula,0) hth Vaya con Dios, Chuck, CABGx3 "Ms Serene" wrote: what do i do to make ="["&J5*0.063&"]" round to the nearest whole number |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
| Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
| Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Hybrid Mode
