Results 1 to 2 of 2

Need formula to show amount of change (+ or -)

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2010
    Location
    Honolulu, HI
    MS-Off Ver
    Excel 2003
    Posts
    1

    Need formula to show amount of change (+ or -)

    How do I create a formula to show me the amount of change between two tests my students have taken? For example, if they scored a 99 on test 1 and a 97 on test 2, I'd like Excel to display the change as a -2 because the score changed 2 points. If they got a 100 on test 2 I'd like Excel to display the change as +1. Thanks!
    Last edited by Alec S.; 03-09-2010 at 03:39 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1