Related Questions

 Tags

Question by  Steph58 (21)

# What is the excel formula for percent?

I need to calculate percentages.

 +1 vote! +7 you voted 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.

 +1 vote! +6 you voted 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.

 +1 vote! +6 you voted 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.

 +1 vote! +6 you voted 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)

 +1 vote! +5 you voted 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.

 +1 vote! +5 you voted 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.

 +1 vote! +4 you voted 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.

 +1 vote! +4 you voted 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.

 +1 vote! +3 you voted 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.

 +1 vote! +3 you voted 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))