| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
rounding the answer of a formula
I want to divide one number by another and round the answer up to the
nearest hundreth. Ie, 38 inches divided by 12 equals 3.17. Right now I can DISPLAY the 3.17 but when using that in a formula it's calculating with 3.1667 Thanks in advance Boze |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Formula gives me the same answer | Excel Discussion (Misc queries) | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
| I need to get this answer 8 - 1.2 = 6.2 from a formula | Excel Worksheet Functions | |||
| If and (and) formula to allow a zero answer | Excel Worksheet Functions | |||
Threaded Mode
