Help

Formula Help Needed

Topic Labels: Formulas
491 3
cancel
Showing results for 
Search instead for 
Did you mean: 
BTCM
4 - Data Explorer
4 - Data Explorer

I am trying to create a formula for the following information

Overtime $

This field is Overtime Hours *.50 * Pay Rate

However, I just get ERROR, and I am stuck

This was the excel formula =SUM(D4*0.5)*B4

D4 being Overtime Hours and B4 being Pay Rate

3 Replies 3
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

The following should work

({overtime hours} * .5) * {pay rate}

an error may return if either of those fields are empty. 

BTCM
4 - Data Explorer
4 - Data Explorer

Yeah I tried that already, and it is showing error and even if the hours for Overtime are 0 I put a 0 in the field. 

Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @BTCM - I just tested it and it works even if fields are empty or zero

Zack_S_0-1692896112951.png

Formula:

 

Zack_S_1-1692896125097.png

Is your pay rate field being brought in by a lookup field by chance?