Formula Help

Brass Contributor

Attached is the example workbook with the instructions on what I need inside.

 

I need a formula for if the point time column is greater than 8 then divide HS by 8. If it is less than 8 then divide HS by the Point Time.

 

Thanks in advance

 

1 Reply

@catherine9910 

In row 3:

 

=H3/MIN(J3,8)

 

Fill down.