Forum Discussion
Mocha365
Aug 22, 2024Copper Contributor
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)
- =IF(A1 <= 1, 40, 40 + (25 * A1) - 25)
2 Replies
- CookieMonster1992Copper Contributor=IF(A1 <= 1, 40, 40 + (25 * A1) - 25)
- Mocha365Copper ContributorFormula worked, thank you!