Question: Write an excel code that shows if the student pass or fail, note that if the student got 60 or more in at least 2

Write an excel code that shows if the student pass or fail, note that if the student got 60 or more in at least 2 exams then the student passed and write pass, if not write fail Write an excel code that shows if the student pass or fail,

(1) Write VBA function that mimic the work of VLOOKUP function. You must: Use the function name MYVLOOKUP. Use while loop inside the function. Use all the following input parameters: VR The lookup Value Row index. VC The lockup Value Column index. SR The index of the lockup table Starting Row. SC The index of the lockup table Starting Column ER The index of the lockup table Ending Row. EC The index of the lockup table Ending Column. OC The Output Column. Assume that: The lookup value is a numeric value. The lookup table is sorted in an ascending order. The function should behave like range lookup function. Hint: instead of using the standard VLOOKUP function you need to call the function MYVLOOKUP as shown below VLOOKUP(E4, Al: C10 ,3) MYVLOOKUP(4,5, 1,1, 10,3,3) Both functions should give the same result. (1) Write VBA function that mimic the work of VLOOKUP function. You must: Use the function name MYVLOOKUP. Use while loop inside the function. Use all the following input parameters: VR The lookup Value Row index. VC The lockup Value Column index. SR The index of the lockup table Starting Row. SC The index of the lockup table Starting Column ER The index of the lockup table Ending Row. EC The index of the lockup table Ending Column. OC The Output Column. Assume that: The lookup value is a numeric value. The lookup table is sorted in an ascending order. The function should behave like range lookup function. Hint: instead of using the standard VLOOKUP function you need to call the function MYVLOOKUP as shown below VLOOKUP(E4, Al: C10 ,3) MYVLOOKUP(4,5, 1,1, 10,3,3) Both functions should give the same result

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!