Question about Microsoft Excel for PC

1 Answer

How to create a formula for increase decrease percent in excel

Posted by Anonymous on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    New Friend:

    An expert that has 1 follower.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 38 Answers

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).

Posted on Sep 08, 2014

Ad

4 Suggested Answers

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

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

Les Clayton

  • 214 Answers

SOURCE: average handle time

I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

Posted on Apr 08, 2008

JackHeath

NA NA

  • 1049 Answers

SOURCE: i want the all excel formulas

You will never find a fully comprehensive list anywhere because there are literally hundreds in the basic Excel application and thousands that can be added in as you go via macros. More are being added every time a new version of Office comes out.

But, the easiest way however to get a basic list of functions if your not printing is to hit the function button and simply scroll down the list. The syntax (an example of the method by which you should be formatting the formula) and a definition will list in the bottom of the dialog as you select each function.

That said, you are better solving individual problems as you learn Excel then trying to memorize all the functions themselves. Many, such as mathematical operations are common sense anyway.

Posted on Jun 19, 2009

Anonymous

  • 66 Answers

SOURCE: how to create a game trivia from microsoft

There are a couple of web sites out there have have good directions. Try these:

http://supportpcs.co.uk/index.php?option=com_content&task=view&id=152&Itemid=30

or

http://college.cengage.com/accounting/resources/instructors/air/fall_2006/Connell_and_Mulig_Paper.html

Posted on Sep 12, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Formula in excel 2013 for if statement


google-- user manual for excel-- and you will find that information in the 900 pages of the pdf version download

Oct 17, 2017 | Excel Computers & Internet

1 Answer

I cashed in $28000.00 from a deposit of $25000.00 after a year how much per cent did i earn . what is the formula


Percent change=100% * (NEW value-OLD value)/(OLD value)
If the change is positive, that is an increase. If negative, that is a decrease.

Sep 18, 2014 | The Learning Company Achieve! Math &...

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

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

Insert a calculated field named % Change in Value to determine the percent change in values by type in Excel?


If field A1 is the old value and A2 is the new value, then the formula for A3 (% change) is:=(A2-A1)/A1*100You can remove the *100 if you want to format the field to the Percent type.

Sep 30, 2011 | Microsoft Excel 2010

1 Answer

VLOOKUP Formula


Using IF function or filter to generate the membership type and create a VLOOKUP for that..... Or using filter function you could create a pivot and insert the specific formula per type in that.

Feb 10, 2009 | Microsoft Excel for PC

1 Answer

Countifs


The formula in both versions is the same:

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.
=countif(A1:B9,1)

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

4 Answers

I need Excel's Furmula's


I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

This link has some custom formulas for excel that you can download:

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

379 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

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

Answer questions

Manuals & User Guides

Loading...