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