I have a column in a spreadsheet that contains a formula:

=1-(L851/K851)

Using this formula, I calculate the percentage discount that a customer gets
off a particular item. I formatted the column as a percentage with one
decimal. The result shows a number with one decimal that is correct.

However, when I move that into a pivot table, I get the multiple decimals
(up to 15 digits). So I can't group calculate everything that is say 47.5%
discount. I have multiple 15 digit numbers all listed separately that would
round to 47.5%. My pivot table field is also formatted to a single digit.

So I think that maybe I need to round the results in the original data.
Which brings me to my very basic question. How do I do that? I found the
section on worksheet functions, but I don't know how to put that into each
cell with the formula.

What is my formula if I want to round this to a single decimal result?
Again, my current formula is:

=1-(L851/K851)

Thanks.

Kathy

enclose your formual in a ROUND() function:

=ROUND(1-(L851/K851),1)


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"kleivakat" wrote in message
...
I have a column in a spreadsheet that contains a formula:

=1-(L851/K851)

Using this formula, I calculate the percentage discount that a customer
gets
off a particular item. I formatted the column as a percentage with one
decimal. The result shows a number with one decimal that is correct.

However, when I move that into a pivot table, I get the multiple decimals
(up to 15 digits). So I can't group calculate everything that is say
47.5%
discount. I have multiple 15 digit numbers all listed separately that
would
round to 47.5%. My pivot table field is also formatted to a single digit.

So I think that maybe I need to round the results in the original data.
Which brings me to my very basic question. How do I do that? I found the
section on worksheet functions, but I don't know how to put that into each
cell with the formula.

What is my formula if I want to round this to a single decimal result?
Again, my current formula is:

=1-(L851/K851)

Thanks.

Kathy

Don't you want =ROUND(1-(L851/K851),3) rather than =ROUND(1-(L851/K851),1),
Sandy?
Kathy was asking for one place of decimals *when formatted as a percentage*.
--
David Biddulph

"Sandy Mann" wrote in message
...
enclose your formual in a ROUND() function:

=ROUND(1-(L851/K851),1)

"kleivakat" wrote in message
...
I have a column in a spreadsheet that contains a formula:

=1-(L851/K851)

Using this formula, I calculate the percentage discount that a customer
gets
off a particular item. I formatted the column as a percentage with one
decimal. The result shows a number with one decimal that is correct.

However, when I move that into a pivot table, I get the multiple decimals
(up to 15 digits). So I can't group calculate everything that is say
47.5%
discount. I have multiple 15 digit numbers all listed separately that
would
round to 47.5%. My pivot table field is also formatted to a single
digit.

So I think that maybe I need to round the results in the original data.
Which brings me to my very basic question. How do I do that? I found
the
section on worksheet functions, but I don't know how to put that into
each
cell with the formula.

What is my formula if I want to round this to a single decimal result?
Again, my current formula is:

=1-(L851/K851)

Thanks.

Kathy

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Don't you want =ROUND(1-(L851/K851),3) rather than
=ROUND(1-(L851/K851),1), Sandy?

No I don't want it but the OP certainly does! <g

Thanks for the catch - I missed that point completely.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Don't you want =ROUND(1-(L851/K851),3) rather than
=ROUND(1-(L851/K851),1), Sandy?
Kathy was asking for one place of decimals *when formatted as a
percentage*.
--
David Biddulph

"Sandy Mann" wrote in message
...
enclose your formual in a ROUND() function:

=ROUND(1-(L851/K851),1)

"kleivakat" wrote in message
...
I have a column in a spreadsheet that contains a formula:

=1-(L851/K851)

Using this formula, I calculate the percentage discount that a customer
gets
off a particular item. I formatted the column as a percentage with one
decimal. The result shows a number with one decimal that is correct.

However, when I move that into a pivot table, I get the multiple
decimals
(up to 15 digits). So I can't group calculate everything that is say
47.5%
discount. I have multiple 15 digit numbers all listed separately that
would
round to 47.5%. My pivot table field is also formatted to a single
digit.

So I think that maybe I need to round the results in the original data.
Which brings me to my very basic question. How do I do that? I found
the
section on worksheet functions, but I don't know how to put that into
each
cell with the formula.

What is my formula if I want to round this to a single decimal result?
Again, my current formula is:

=1-(L851/K851)

Thanks.

Kathy