Applications Software Lessons

Applications Software Lessons (9)

When you walk around the place where you live, most of the times, you feel pretty safe and comfortable, right? Now imagine if there were land mines buried right here, scattered around, and you'd never know when you might step on one.

This formula will find Dropout, Vacated and Graduated status according to number of months trainees attended to the Vocational Training Centre
Example Data used are as follows;
 
Click here to download sample data Excel file.
 
Conditions are as follows;
1. If trainee is in Baker (BEK) course and attendance are lower than 1.5 months he or she will be marked as "Dropout"

2. If trainee is in Computer (COM) course and attendance are lower than 1.5 months he or she will be marked as "Dropout"
 

3. If trainee is in Automobile Mechanics (MOM) course and attendance are lower than 3 months he or she will be marked as "Dropout"

4. If trainee is in Electric (ELT) course and attendance are lower than 3 months he or she will be marked as "Dropout"

5. If trainee is in Carpenter (CAR) course and attendance are lower than 3 months he or she will be marked as "Dropout"

6. If trainee is in Welder (WEL) course and attendance are lower than 3 months he or she will be marked as "Dropout"

7. If trainees are attended lower than 9 months they are marked as "Vacated" and if not, that mean if they are attended greater than 9 months they are calculated as graduated.
 
8. If trainee received the NVQ certificate and marked as “Yes” in NVQ Graduated column, they are marked as “NVQ Graduated”

Full formula:

Yellow colored part of the formula will hide all the #NUM! Errors and show 0 instead of #NUM!. This #NUM! value will be displayed when either “Admission date” or “Departure Date” cells are empty.

Here, as part of our beginner's guide to Adobe Photoshop, we show you how to use actions and batch processing to resize multiple images.

Join Our YouTube Channel

පරිගණක විද්‍යාව ගැන, හැකින් ගැන, මනෝවිද්‍යාත්මක කරුණු වගේම මුල්‍ය ශාක්ෂරතාවය පිළිබඳ වීඩියෝ පාඩම් සිංහලෙන්ම ඉගෙන ගන්න ඔබත් අදම මේ දැන්ම මගේ YouTube නාලිකාවත් සමඟ එකතු වෙන්න. එන්න පහත ලින්ක් එකට ගිහින් Subscribe කරන්න.
Link: https://www.youtube.com/c/KDKTECICTProfessionalsInSriLanka 

Articles Archive

Articles Calendar

« April 2019 »
Mon Tue Wed Thu Fri Sat Sun
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30          
002243015
Today
Yesterday
This Week
Last Week
This Month
Last Month
All days
3462
2859
24713
1688016
82366
121143
2243015
Your IP: 18.232.147.215
2019-04-19 15:02

Video Of The Day

Subscribe to PC WORLD Magazine

Joomla forms builder by JoomlaShine
Go to top