Section 1 of 1 in this document

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

Enter your wages

Calculated Wages