| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
include rounding in a formula
i have the following:
A B C 1 327.2 3033.56 0.107860072 column C1 is simply A1/B1 . Is there a way that i can include in my formula to round the results to 0.11? What I have been doing is creating another column and entering the formula: round(c1,2) then copying and pasting values I am hoping to eliminate these steps and somehow include the rounding function in the formula. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| How do include Dates in a formula? | Excel Worksheet Functions | |||
| Sum if formula to include value in col Q when no value in col P for that row | Excel Discussion (Misc queries) | |||
| specific rounding of formulas which may need to include an IF stat | Excel Worksheet Functions | |||
Threaded Mode
