Results 1 to 4 of 4

multiple "if" functions depending on previous functions

Threaded View

andyr85 multiple "if" functions... 08-20-2012, 09:15 AM
Ace_XL Re: multiple "if" functions... 08-20-2012, 09:27 AM
andyr85 Re: multiple "if" functions... 08-20-2012, 10:05 AM
NBVC Re: multiple "if" functions... 08-20-2012, 09:28 AM
  1. #1
    Registered User
    Join Date
    08-18-2010
    Location
    Worcester
    MS-Off Ver
    Excel 2007
    Posts
    11

    Smile multiple "if" functions depending on previous functions

    Hi all, I'm struggling to get this formulae to work right! I'm a teacher and want to develop a grid to track marks for assessments and work out points.

    If a candidate gets all the Ps ( 9 in total for unit 2) They get 12 points, if they get the 7 Ms they get another 6 points making 18, if they get all 5 Ds they get another 6 points to make 24. I have that bit sorted, the tricky part is if an M is missing, they are limited to 12 points (even if they have all the other Ms and Ds) and if any P is missing, they get 0.

    Any help would be much appreciated!! See attached spreadsheet.

    I have used the countif function to count the Ps, Ms and Ds in the cells as a helper column to the right.

    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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