Forum Discussion
Musical1FL
Feb 26, 2025Copper Contributor
Formula to Render zero if another field is empty
Hi, I have a to calculate hours worked on a spreadsheet but the first hour is $50 and the subsequent hours are $35/HR .. so I built a column to add $50 which is populated when the hours are en...
HansVogelaar
Feb 26, 2025MVP
In G5:
=IF(E5>0, 50, 0)
or
=(E5>0)*50
In H5:
=MAX((E5-1)*35, 0)
Fill down.