Prev: Name scope within a workbook
Next: Hide unused rows and columns
From: KrispyData on 24 Mar 2010 18:38
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?
From: Lars-�ke Aspelin on 24 Mar 2010 18:40
On Wed, 24 Mar 2010 15:38:01 -0700, KrispyData
<KrispyData(a)discussions.microsoft.com> 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
From: kyleb on 24 Mar 2010 19:01
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?
 | 
Pages: 1
Prev: Name scope within a workbook
Next: Hide unused rows and columns