If function to show the expected result

mikail

New member
Joined
Feb 14, 2014
Messages
1
Reaction score
0
Points
0
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.:sad:
 

Attachments

  • Student training.xlsx
    9.3 KB · Views: 14

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,769
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Where is the score entered? Could you please add BEFORE and AFTER to your sheet ? Thx
 
Top