Results 1 to 3 of 3

Thread: Please HELP with IF(AND function!!!

  1. #1

    Exclamation Please HELP with IF(AND function!!!

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Okay so I am trying to create a leaderboard and I have the function almost complete. What I am trying to do is I need to give points based on if a certain score was met. There are 4 different points given if they meet a certain % criteria. Got that. My isssue is that 3 out of the 4 points are only given IF the 1st score is met. So here is the function I have now. I just cannot figure out for the life of me how to add that IF the TrnOvr % is met, then the points are given. My Metrics (ex. TrnOvr, PPP etc...) are in differnt columns that the scores. Here is what I have now. And it works except for excluding the points if the TrnOvr criteria is not met.

    Please HELP!!!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    Kind of confusing,

    Can you show us a sample of your worksheet, and what you are trying to achieve?

  3. #3
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Wouldn't it just be something like


Posting Permissions

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