Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    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
    Attached Files Attached Files

  3. #3
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help Needed (2000 SR-1)

    Thanks very much Andrew, exactly what I wanted!

  4. #4
    New Lounger
    Join Date
    Sep 2001
    Location
    Warner Robins, Georgia, USA
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •