| View Question |
|
|
 | ||
|
| Subject:
Excel Formula
Category: Business and Money > Accounting Asked by: woserbop-ga List Price: $2.00 |
Posted:
11 May 2005 03:41 PDT
Expires: 11 May 2005 16:28 PDT Question ID: 520360 |
Anyone know how to write the following formula in excel? My sister in law is doing a project at work and for some reason needs to create this formula For every 1% change, result = 5% in the opposite direction Examples: 1% = -5% -2% = 10% |
| ||
|
| There is no answer at this time. |
| ||
|
| Subject:
Re: Excel Formula
From: xarqi-ga on 11 May 2005 04:15 PDT |
If 1% was in cell A1, you could put this formula into B1 to have the desired effect: =-(A1 * 5) |
| Subject:
Re: Excel Formula
From: xarqi-ga on 11 May 2005 04:15 PDT |
or a little simpler: = A1 * -5 |
| Subject:
Re: Excel Formula
From: syvan-ga on 11 May 2005 15:54 PDT |
If you are using a beginning number and an ending number, rather than having a shown percentage, this is a formula to use, where A1=beginning number, and B1=ending number. =-(B1-A1)*5+A1 |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
| Search Google Answers for |
| Google Home - Answers FAQ - Terms of Service - Privacy Policy |