[GovOS, A Kofile Company] IF WF Example

IF Function Example

Formula used: IF(F2>0,F2*F1,(F4/F3)*F1)

F1= Total Time worked in hours

F2= Enter your wages

F3= Hourly Rate Pre Tax

F4= Hours Per Year

Total time worked in hours (3 hrs 45 min is 3.75 hours)

Enter your wages

Hourly

Salary

Hourly Rate Pre Tax

Hours Per Year (Standard is 2080)

Salary (decimals ok, no commas ex: 48808.23 not 48,808.23)

Calculated Wages