S
sfslash
I am new to excel VB, need some help for my course work, here is th
question with requirement and banned command, it looks pretty easy, bu
no matter how I tried, it always come up #VALUE, please help me, thi
is due in soon. Thank You.
write a user-defined function for Calculate the wages of a person wh
can work up to 100 hours a week and will be paid overtime for time ove
39 hours a week. Lunch, however, is unpaid
List of Requirements
You must attempt to use all of the following features in you
user-defined function:
1. Use arguments to pass values into your function from th
spreadsheet
2. Use the function name to return the answer to the spreadsheet
3. Use at least one constant (local or global)
4. Use at least one local variable
5. Declare all variables, constants and the function name with a
appropriate data type
6. Use at least one loop structure
7. Use at least one branching decision structure
8. Nest loops and decision structures
9. Use the correct naming conventions for all variables, constants an
the function name
10. Use correct indentation of code blocks, especially within loops an
decision structures
List of Banned features
The following features can NOT be used in your user-defined function:
1. GOTO statements
2. Exit commands
3. Error handling
4. Data Validation (except where you have written the code your sel
with loops and decision structures and have fully commented what yo
are doing)
5. Line numbers or line labels
6. Subs or property procedures
7. Calling a function from within a functio
question with requirement and banned command, it looks pretty easy, bu
no matter how I tried, it always come up #VALUE, please help me, thi
is due in soon. Thank You.
write a user-defined function for Calculate the wages of a person wh
can work up to 100 hours a week and will be paid overtime for time ove
39 hours a week. Lunch, however, is unpaid
List of Requirements
You must attempt to use all of the following features in you
user-defined function:
1. Use arguments to pass values into your function from th
spreadsheet
2. Use the function name to return the answer to the spreadsheet
3. Use at least one constant (local or global)
4. Use at least one local variable
5. Declare all variables, constants and the function name with a
appropriate data type
6. Use at least one loop structure
7. Use at least one branching decision structure
8. Nest loops and decision structures
9. Use the correct naming conventions for all variables, constants an
the function name
10. Use correct indentation of code blocks, especially within loops an
decision structures
List of Banned features
The following features can NOT be used in your user-defined function:
1. GOTO statements
2. Exit commands
3. Error handling
4. Data Validation (except where you have written the code your sel
with loops and decision structures and have fully commented what yo
are doing)
5. Line numbers or line labels
6. Subs or property procedures
7. Calling a function from within a functio