What is the excel formula for percent?

Answer by  gigo (1706)

Just multiply the percent value by 0.01. Write for example the formula =A1*0.01*b1. With A1 as the value to take the percentage from and B1 as the percent input field.

Answer by  NarenMukherjee (308)

Suppose A2=23. 94 and B2=10 then C2: =(A2-B2)/A2, will produce 0. 582289055973267 Format C2 as Percent it will display you 58%, if no decimal is selected.

Answer by  blahblah (670)

First, calculate the value; then display the results as a percentage. For example to find what percent 15 is of 60, type in the formula bar: =15/60 Or, to use numbers from cells, type, for example: =A3/B3 Then, put your cursor on the cell with the calculation and click on the % button in the toolbar.

Answer by  mahes (32209)

Cell C1= B1/A1 Important : C1 Format Cell= Percentage & Decimal Places = 2 Result= 1. 24%(or If $2000. 00 is in say C1 and $50. 00 for Cable TV in C2, then you can use say in D2: =C2/$C$1)

Answer by  Bogdan (46)

Follow this simple examples: 19% means 0.19, 85% is 0.85, you need to divide (ex: 19)to 10 and it will result 0.19.

Answer by  Mazer (173)

There are two ways to do this: in a given cell either enter the formula "=(a/b)*100" or right-click on the cell, click Format Cell, in the dialog that opens select the Percent format inside the Number category and click OK, then enter the formula "=a/b" This formatting will display a % symbol next to result.

Answer by  Munawer (365)

For example, enter number 2 in cell A1 and number 4 in cell A2. In cell A3 type "=A1/A2" (exclude quotes) and click the % sign on the menu bar.

Answer by  anbu (5968)

A2: 23. 94 B2: 10 C2: =(A2-B2)/A2 will produce 0. 582289055973267 format C2 as Percent with the number of decimal places you desire (or none at all) and will display you 58% you can drag fill this formula down the column.

Answer by  satdeepa (39)

Usually percentages are calculated with the amount divided by total or click percentage % on the formatting toolbar.formulla is A2/B2.

Answer by  brian7754 (243)

To calculate the percentage, you have to take a value and divide it by the sum of all values. Assuming cell A1 = 3, A2 = 9, A3 = 3. The sum of all values is 15. 9 (cell A2) is 60% of the total. The formula to calculate this percentage would be: =A2/(SUM(A1:A3))