Basic Rounding Format question

[Guest]

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[David Biddulph]

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*.

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk