Scribd
Upload
40 views13 pages

VBA If Ka Question

The document evaluates eligibility for bonuses based on salary, division, and performance ratings, with specific criteria for different divisions. It also assesses students' pass/fail status based on geography and civics scores, using both AND and OR conditions. Additionally, it includes a scoring system for individuals based on their ratings, categorizing them as Good, OK, or Bad.

Uploaded by

aaryamansh345
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
40 views13 pages

VBA If Ka Question

The document evaluates eligibility for bonuses based on salary, division, and performance ratings, with specific criteria for different divisions. It also assesses students' pass/fail status based on geography and civics scores, using both AND and OR conditions. Additionally, it includes a scoring system for individuals based on their ratings, categorizing them as Good, OK, or Bad.

Uploaded by

aaryamansh345
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

FIND OUT WHETHER THE PERSON IS ELIGIBLE OR NOT ELIGIBLE FOR BONUS

Name Salary p.a. (US$) Division Rating


Gopal Agrawal 38,261 HFD 3
Aniket Khirsagar 82,135 RAD 4
Rahul Shirude 24,566 HFD 1
Raju Chudiwal 25,000 CDFD 2
Pramod Pawar 38,038 HFD 1
Pandhari Tayde (SIR) 72,682 RAD 3
Philip Bhalerao 353,556 ED 5
Pavan Lalwani 55,089 RAD 2
Sonal Agarwal 35,000 CDFD 1
Ajinkya Deshmukh 98,527 RDD 4
Gopal Agrawal 20,337 CDFD 1
Aniket Khirsagar 18,158 CDFD 3
ELIGIBLE FOR BONUS
Rating 1-3 AND Division "CDFD" AND Salary < 50K
Not Eligible
Not Eligible
Not Eligible
Eligible
Not Eligible
Not Eligible
Not Eligible
Not Eligible
Eligible
Not Eligible
Eligible
Eligible
Question
Geography > 40 AND Civics > 20 then Pass else Fail

Geography Civics
Name (Marks out of 100) (Marks out of 50)
Sonal Agarwal 44 34
Palak Bharuka 88 22
Shraddha D 81 12
Rupali S 81 11
Roopa B 60 44
Nilima B 12 23
Jayshree T 11 23
Result
Pass
Pass
Fail
Fail
Pass
Fail
Fail
Question
Geography > 40 OR Civics > 20 then Pass else Fail

Geography Civics
Name (Marks out of 100) (Marks out of 50)
Umesh S 44 34
Mahesh S 88 22
Rahul Khandelwal 33 12
Vijay Lalwani 81 11
Rahul Mohite 60 44
Dilip Thete 12 11

Total Amount Rate /Unit Total Unit


210 35
Result
Pass
Pass
Fail
Pass
Pass
Fail

Question

Find the Total Unit and if the Total Unit return


the Total Unit returns Error, replace the same with a Text " Please Enter Value more than 0"
Enter Value more than 0"
Name Score 1 Score 2 Result Question
Richard 12 34 if the first score is greater than or equal to
Stephen 28 56 greater than or equal to 90, Result shou
John 81 12
Natasha 81 95
Elvin 60 71
Joseph 12 74
ater than or equal to 60 or the second score is
to 90, Result should be "PASS" Else "FAIL"
STATUS

Name Rating Rating Output

Ajay Sharma 3 Good


Aniket Kshirsagar 4 OK
Gopal Bharuka 1 Good
Mahesh Siroya 5 OK
Umesh Siroya 1 Good
Nilesh Jaiswal 6 BAD
Palak Bharuka 5 OK
Sonal Agarwal 7 BAD
Pandhari Tayde 1 Good
Pramod Pawar 8 BAD
Rahul Khandelwal 1 Good
Rahul Mohite 2 Good
1-3 Good
4-5 OK
6-8 Bad

You might also like