Thread: Formula Help Needed (2000 SR-1)

1. Formula Help Needed (2000 SR-1)

I need to create a spreadsheet to figure the differences between money amounts each day and show them as percent of change in both positive and negative numbers whichever the case may be. I am a newbie with working with formulas so don't worry about over explaining the solution, I want to learn!
Thanks

2. Re: Formula Help Needed (2000 SR-1)

Jim,

If you have your daily amounts in say column A, starting in A2, then in B3 if you enter <pre> (A3-A2)/A2</pre>

it should give the % difference betweeen the two.

To display that difference as a % you need to use number formatting and the follwing format shold suit : <pre> +0.00%;{Red} -0.00%</pre>

That should display .05 as 5.00% if positive and <font color=red>-5.00%</font color=red> if negative. Note you are going to have replace the { } brackets around Red with [ ].

I have attached a very simple spreadsheet to show it in place.

Andrew C

3. Re: Formula Help Needed (2000 SR-1)

Thanks very much Andrew, exactly what I wanted!

4. Re: Formula Help Needed (2000 SR-1)

It never fails to amaze me how I can always get help from this site. For the life of me I couldn't remember how to do this and a quick search (after opening lots of books) solved my problem.
THANKS!!!!

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•