Question about Microsoft Excel for PC

1 Answer

Percentage formula need a formula for working out 30% for any given figure to add into a spreadsheet

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 4 Answers

=(Click cell that you want to work out 30% of)*30/100

Posted on Nov 30, 2008

1 Suggested Answer

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,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to work out percentage of items


The concept of "percentage difference" depends upon what you use as your comparator, or the "base" amount.

Suppose the 8.50 value is entered in cell B3 and 4.80 is entered in cell C3.

To compute what percentage you'd save (off the higher price) if you buy from the cheaper supplier, you could enter into cell D3 a formula like: =(B3-C3)/B3
This would result in a numeric value of 0.435294, meaning you'd save about 43.53% off the higher price. In this case, your "base" amount is $8.50.

Alternatively, if you used the lower price as the "base", then you could use a formula like: =B3/C3
This would result in a numeric value of 1.770833, meaning the higher price is 177.08% of the lower price, so it costs about 77% more.

HTH!

Feb 03, 2014 | Avanquest Spreadsheet Professional Full...

1 Answer

Page break insert


In an empty cell on sheet 1 press =
then click the cell that contains the first figure
press +
switch to sheet 2
click on the cell that contains the 2nd figure
press enter
go and look at sheet one and see the answer :-)

In my spreadsheet this cell now contains the formula
=A3+Sheet2!A1

Nov 15, 2013 | Office Equipment & Supplies

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

1 Answer

I am working on a spreadsheet for my boss that will allow him to track the progress of our sales team. I've done the formatting, etc, but am now onto the formulas. I have suggested revisions to the sheet...


Try having the cells refer to the ones you would like in the formula then have a statement something like if a = 1 then yes or if a = 2 then no and have it after become a percentage by dividing the sum by the count. Let me know if you need more help.

Dec 17, 2008 | 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

Excel Spreadsheet


It could have a virus or simply too much data in it or too much data linked to it. Try doing a copy of the whole spreadsheet, and then paste the data into a new spreadsheet. If it doesn't contain too many different formulas, try pasting only the values, and then replace the formulas manually. You might also try just deleting the links, if there are any. If this doesn't solve it, reply to this thread and let us know.

Hope this will FixYa!!!

Sep 30, 2008 | Microsoft Excel for PC

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

2 Answers

Help


go to page setup and under scaling you can adjust to your required percentage

Jul 22, 2008 | Microsoft Excel for PC

2 Answers

Should I use countif or if or what ??


hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

148 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18343 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...