Hi all,
I am a complete beginner so please bear with me
Ive just started computer science and am stuck with one of my assignments
The exercise I struggle with is below.
I assume I must ask the user for the different values and make an "IF statement" for the last part calculating the bonus according to the number of hours worked but I don't know how to put the equation for the number of hours (overtime - (2/3)*Absent) into the macro.
Exercise:
Write VBA macro to read a employee name (NAME), overtime hours worked (OVERTIME), hours absent (ABSENT) and determine bonus payment (PAYMENT).
Use the following table to calculate bonus payment
Bonus Schedule OVERTIME – (2/3)*ABSENT Bonus Paid >40 hours
>30 but £ 40 hours
>20 but £ 30 hours
>10 but £ 20 hours
£ 10 hours$50
$40
$30
$20
$10
please, help! many thanks in advance