Why percentage calculation in excel gives me incorrect numbers

Question

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.

Answer 1

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