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 subtrac...
- Aug 22, 2024=IF(A1 <= 1, 40, 40 + (25 * A1) - 25)
CookieMonster1992
Aug 22, 2024Copper Contributor
=IF(A1 <= 1, 40, 40 + (25 * A1) - 25)
- Mocha365Aug 22, 2024Copper ContributorFormula worked, thank you!