Question about Business & Productivity Software

1 Answer

Percentage formula when in excel, wot is the formula for calculating percentage

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Brigadier General:

    An expert that has over 10,000 points.

  • Master
  • 6,966 Answers
Re: percentage formula


Since you are asking for the formula, it depends where your values are (cell). Please refer to the example below.


Good luck and kind regards.

Posted on Dec 09, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

What is formula to find percentage of females in my workplace?

      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

    How to Calculate Percentages in Excel > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Business & Productivity Software

2 Answers

What is the percentage increase if one cell is blank and the other is 383 in Microsoft Excel 2010?

That is an unsolveable question. You have to have a Non Zero Starting point in order to calculate a percentage of increase. Black is essentially 0. and no % increase of 0 will bring you anything but 0

Sep 08, 2014 | Microsoft Excel 2010

1 Answer

How to create a formula for increase decrease percent in excel

If you have a number in Cell A2 (say 100), and you put the amount of percentage increase or decrease in Cell A3 (say -10%), then put this formula into Cell A4 to calculate the answer:
=A2*(1+A3) , which then shows as the answer (90).

Sep 05, 2014 | Microsoft Excel for PC

1 Answer

How do i calculate a difference in a percent?

If the value in A1 is 100, and the value of A2 is 120, then the formula =(A2/A1)-1 will return 0.2. If the cell containing the formula is then formatted to display as percentage it will show as 20%.

Dec 13, 2013 | Microsoft Excel for PC

1 Answer


There isn't a function for this, but the formula should be something like this:
A1: Number to increase / decrease
B1: % change
C1: 'INC' or 'DEC'
D1: =IF(C1='INC', A1+(A1*B1), A1-(A1-B1))

Nov 17, 2011 | Microsoft Excel for PC

1 Answer

How to add % (Percentage column ) in the excel

The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Jan 03, 2009 | Microsoft Business & Productivity Software

4 Answers

I want the excel compound interest formula


Dec 02, 2008 | Microsoft Office Professional 2007 Full...

2 Answers


how to do substract in exccel

Oct 08, 2007 | Microsoft Office Standard for PC

1 Answer


If your A5 cell contains 235 and B5 cell contains 25 Then type following formula in cell C5 = Roundup(A5/B5,0) this will give you answer 10 .Other wise you can put formula in cell D5 as Roundup(C5,0)and in C5 put A5/B5

Oct 07, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

580 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides