I am trying for a formula that if cell i2 is 0, then add J1+h2 = 25,000
The formula I am using works ok if all cells have a value but does not work with a 0 in the cell i1
=IF(KI1>0,I4+H2,0)
The formula I am using works ok if all cells have a value but does not work with a 0 in the cell i1
=IF(KI1>0,I4+H2,0)
2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 0 | 2,500 | 2,500 | 0 |
2,500 | 5000 | 7500 | 10000 | 12500 | 15000 | 17500 | 20000 | 0 | 0 | 2500 | 0 |
1,453 | 2,905 | 4,358 | 5,810 | 7,263 | 8,715 | 10,168 | 11,620 | 0 | 0 | -9,023 | 0 |