Results 1 to 11 of 11

replacing lowest test grade with final if final is higher formula help

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2010
    Location
    San Antonio TX
    MS-Off Ver
    Excel 2007
    Posts
    14

    replacing lowest test grade with final if final is higher formula help

    Hello all,
    I am putting together a gradebook and am having problems coming up with an IF statement to replace the lowest, non zero test grade with the final.

    If A1:A4 are the test and A5 is is the final, what would I need to do for the formula to look at the lowest, non zero test of those 4 and if the final is larger, replace it?

    Thanks
    Last edited by colbyclay; 08-27-2010 at 02:18 PM. Reason: Issue was solved!!!

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