Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help to develop a % formula
Greetings,
I'm hoping someone may be able to help me. I have developed a workbook to track my portfolio on a weekly basis. One component of my portfolio is my "Line of Credit" which always contain negative values. For example, last week I had a -$5,000 balance and this week I have a -$6,000 balance. The week over week change is -$1,000 or -20%. Presently, my workbook correctly reflects the -$1,000 weekly change but shows the percentage change as a positive (rather than a negative) 20% weekly change. The formula for weekly % change that I am using is as follows: =+(B421-B420)/B420 (where B421 is this week's negative balance of -$6,000 and B420 is last week's negative balance of -$5,000.) Could you please tell me how to change the formula (or anything else) so that my workbook will reflect the -20% weekly change? By the way, the formula I am using to determine my $ weekly change is simply: =+B421-B420 Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help to develop a % formula
Firstly you don't need a + at the beginning of your formulae.
=+(B421-B420)/B420 is the same as =(B421-B420)/B420 =+B421-B420 is the same as =B421-B420 If you want to change the sign of your answer, change =(B421-B420)/B420 to =(B420-B421)/B420 or =(B421-B420)/-B420 or =-(B421-B420)/B420 or =(B421-B420)/ABS(B420) or ... Note that your current formula is correctly showing the change a percentage of the original value. -$1000 is indeed 20% of -$5000, not -20%, but if you want -20%, just change the sign as shown above. -- David Biddulph cajun-bob wrote: Greetings, I'm hoping someone may be able to help me. I have developed a workbook to track my portfolio on a weekly basis. One component of my portfolio is my "Line of Credit" which always contain negative values. For example, last week I had a -$5,000 balance and this week I have a -$6,000 balance. The week over week change is -$1,000 or -20%. Presently, my workbook correctly reflects the -$1,000 weekly change but shows the percentage change as a positive (rather than a negative) 20% weekly change. The formula for weekly % change that I am using is as follows: =+(B421-B420)/B420 (where B421 is this week's negative balance of -$6,000 and B420 is last week's negative balance of -$5,000.) Could you please tell me how to change the formula (or anything else) so that my workbook will reflect the -20% weekly change? By the way, the formula I am using to determine my $ weekly change is simply: =+B421-B420 Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to develop equation | Excel Discussion (Misc queries) | |||
Develop formula for cash flow | Excel Worksheet Functions | |||
how to develop a formula where assumed value in a cell is used to | Excel Worksheet Functions | |||
How do I develop a forum in Excel? | Excel Discussion (Misc queries) | |||
I need to develop an EFAS table | Setting up and Configuration of Excel |