I am trying to create a formula that when a specific cell number equals or is less than 1, the cell will equal $40. But, if the cell is more than 1 it will equal $40+($25 * “the cell #”) then subtract $25 from that total.

If a tech works an hour or less they get $40 but if they work more than an hour they get $40 plus ($25 multiplied by the extra time over the hour).

ex: working 1.6 hours would equal $55 (($40+($25×1.6))-$25)

​I am trying to create a formula that when a specific cell number equals or is less than 1, the cell will equal $40. But, if the cell is more than 1 it will equal $40+($25 * “the cell #”) then subtract $25 from that total.If a tech works an hour or less they get $40 but if they work more than an hour they get $40 plus ($25 multiplied by the extra time over the hour).ex: working 1.6 hours would equal $55 (($40+($25×1.6))-$25)  Read More

​