Forum Discussion
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 subtrac...
- =IF(A1 <= 1, 40, 40 + (25 * A1) - 25)
=IF(A1 <= 1, 40, 40 + (25 * A1) - 25)
Formula worked, thank you!