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 81 views

## 1 answer to this question.

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
• 53,160 points

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

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

## How to format numbers in excel in crores or lacks

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

## Logical calculation in Excel

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

## Excel get percentage of difference between numbers?

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

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

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

## Convert Rows to Columns with values in Excel using custom format

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

## IF - ELSE IF - ELSE Structure in Excel

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