Forum Discussion

Mocha365's avatar
Mocha365
Copper Contributor
Aug 22, 2024
Solved

Formula for Excel Online

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+($25x1.6))-$25)

Resources