Question about Computers & Internet

Open Question

What is the formula to get percentage in microsoft excel

Posted by Anonymous on

Ad

5 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad
Benimur
  • 6966 Answers

SOURCE: percentage formula

Hi,

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

d770346.jpg

Good luck and kind regards.

Posted on Dec 09, 2007

Ad
dennisgladx
  • 52 Answers

SOURCE: what function can make a text/string BOLD?

Hi,
Try selecting a cell and right click, Format cells, Font - Bold the text the way you want it to appear in that cell and then let it be the value you want to appear when you select that cell as a solution to a "What If" statement.
I build training spread sheets that let people generate pre-programmed answers to various data entries. Answers appear like magic.
Glad to be of assistance - please rate the posting - I can learn from you.

Posted on Oct 26, 2008

  • 3 Answers

SOURCE: formulas in computing grades in excel

www.youtube.com/watch?v=xOU_hL2_zBo

i havent watched it, but i think it might help. hope it helps, enjoy

Posted on Nov 16, 2008

mbase213
  • 728 Answers

SOURCE: HOW TO CALCULATE PERCENTAGE IN MICROSOFT EXCEL?

Hi nastyguy3000;

To calculate a percentage in excel you simply take
amount/total = percentage in your cell

Example A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20)

Have Fun

Mark

Don't forget to leave a rating.

Posted on Feb 19, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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

      https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
    Feedback

    How to Calculate Percentages in Excel

    www.excelfunctions.net > 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

    https://exceljet.net/formula/get-percentage-of-total
    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 | Computers & Internet

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

IS THERE A PERCENTAGE FORMULA TO USE IN EXCEL


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

What is the formula of finding the percentage in a microsoft excel


Assume
A1=50
B1=100
In C1 use the formula: =SUM(A1/B1)

The answer is .5

Then format the cell to % as follows:
Right click the cell, select FORMAT CELLS; on the NUMBER tab select percentage.

Now it will show 50%

Sep 14, 2010 | Microsoft Xbox 360 Console

1 Answer

FORMULA FOR FINDING PERCENTAGE


find "fx" on your toolbar; choose all formulas find percentage, you can set a specific percentage to the cell, just put the number you want a percentage of or if you want to keep that number, put the percentage formula in the next cell <%a:2>

Apr 16, 2009 | Computers & Internet

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:
=b1/a1.

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

Jan 03, 2009 | Microsoft Computers & Internet

4 Answers

I want the excel compound interest formula


=10000*(1+0.96)^12
=10000*(1+0.10)^18
=10000*(1+0.10)^24

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

1 Answer

Percentages in Excel


No problem, Melinda, I am here to help!

If I understood correctly, your spreadsheet looks something like this:
A B C D
1 Question Yes No Total
2 Is sky blue? 20 2 22
3 Is world round? etc.

In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
1) click on the cell where you have the division formula
2) clck on Format in the top menu bar
3) click on Cells
4) click on the Number tab (if you're not already there)
5) click on Percentage in the list of categories
6) click OK

To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

Good Luck!
Regards,
RichMTech

Aug 08, 2008 | Microsoft Excel for PC

1 Answer

How to calculate the percentage


how to use the formula in the word excel

Jun 11, 2008 | Microsoft Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

79 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...