Results 1 to 2 of 2

Thread: If function to show the expected result

  1. #1

    If function to show the expected result



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

    Hi Guys,
    Here is my problem.

    I need to determine when a student needs to attend a refresher training based on below condition:

    If score is 99% to 100%-Need to take refresher training every 12 months
    If score is 90% to 99%-Need to take refresher training every six months
    if score below 90%-Need to take the refresher training every 3 months


    For example: John scored 89% on Feb 2013, the next training will be on May 2013. If in May 2013 he scores 100%, his next training will be on May 2014.
    Attached Files Attached Files

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,504
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Where is the score entered? Could you please add BEFORE and AFTER to your sheet ? Thx

Posting Permissions

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