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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
include rounding in a formula
On Wed, 24 Mar 2010 15:38:01 -0700, KrispyData
wrote: 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? In C1 use this formula: =ROUND(A1/B1,2) Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
include rounding in a formula
The basic structure for the ROUND function is:
=ROUND(formula, # of decimal places) Hope this helps. "KrispyData" wrote: 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? |
Reply |
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 |