|
Basic Rounding Format question
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 |
Basic Rounding Format question
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 |
Basic Rounding Format question
"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 |
| All times are GMT +1. The time now is 09:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com