Question: Use VBA Write a user defined function (UDF) titled VBARocks that: (i) Inputs a in Column B, b in Column C, and c in Column
Use VBA
Write a user defined function (UDF) titled VBARocks that: (i) Inputs a in Column B, b in Column C, and c in Column D; (ii) Checks to see if a is equal to "On" or "Off;: - Multiplies the b value and c value (i.e., b - c ) if a is equal to "On" or divides the b value by the c value (i.e., b/c) if a is equal to "OJf"; and (iii) Outputs the result to Column E
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
