Why percentage calculation in excel gives me incorrect numbers

0 votes
I have the figures below.

2791 Potential Customers and 45 Enrolled Customers

I computed the percentage in Excel as 45/2791, which gave me 16.12, but a calculator gave me 0.0161.

I'm not sure what you mean. Additionally, I checked "set Precision as presented," yet I still get the wrong percentages. Do you know why?

When I calculated 45/2791 multiplied by 100, the answer wasn't right, but when I calculated 45/2791 multiplied by 0.10, the answer was right on the money.

Any settings I should modify? Please inform me.
Dec 11, 2022 in Others by Kithuzzz
• 38,020 points
1,041 views

1 answer to this question.

0 votes

Please be specific with your query. Do you want to divide by a basic number or a percentage? . The formula for percentage is always total * 100.

  1. You are getting 0.0161.. because you have not multiplied by 100.
  2. After multiplying by 100, Percentage = ( 45/2791 ) * 100 = 1.61% i.e Correct
  3. Why result = 16.12.. because ( 45/2791 ) * 1000 = 16.12% i.e Wrong
answered Dec 11, 2022 by narikkadan
• 63,680 points

Related Questions In Others

0 votes
1 answer

Excel formula gives error when write using Apache-poi library in Java

I tested some sample code. The cell ...READ MORE

answered Nov 5, 2022 in Others by narikkadan
• 63,680 points
1,919 views
0 votes
1 answer

How to format numbers in excel in crores or lacks

Try this: =TEXT(A1/10000000,"#,### \cr") READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,680 points
904 views
0 votes
1 answer

Logical calculation in Excel

Excel logical functions - overview. Microsoft Excel ...READ MORE

answered Nov 8, 2022 in Others by gaurav
• 23,260 points
602 views
0 votes
1 answer

Excel get percentage of difference between numbers?

Find the percentage of change between two ...READ MORE

answered Nov 8, 2022 in Others by gaurav
• 23,260 points
742 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
3,851 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,951 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
954 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,592 views
0 votes
1 answer

Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,680 points
1,127 views
0 votes
1 answer

How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 63,680 points
14,571 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP