Hi guys, weird issue I don't know is possible or not. I have 5 rows in my sheet, the first 4 are constants; SUBTOTAL, TAX, TOTAL, DEPOSIT. If I add a second deposit I need the 5th row to show deposit and the amount of the deposit next to it. If there is no second deposit, I need the 5th row to show only the balance of the first 4 rows, and so on for the next few rows. Ideally I would like the first column to go from blank if nothing is mentioned, DEPOSIT if there is another deposit, or BALANCE if there's deposits above it.
| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | If 'B7' does not contain number | If 'B7' contains number | |||||
| 2 | |||||||
| 3 | SUBTOTAL | $49,999.00 | SUBTOTAL | $49,999.00 | |||
| 4 | TAX | $4,312.41 | TAX | $4,312.41 | |||
| 5 | TOTAL | $54,311.41 | TOTAL | $54,311.41 | |||
| 6 | DEPOSIT | $15,000.00 | DEPOSIT | $15,000.00 | |||
| 7 | BALANCE | $39,311.41 | DEPOSIT | $15,000.00 | |||
| 8 | BALANCE | $24,311.41 | |||||
Sheet1 | |||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B4,E4 | B4 | =B3*0.08625 |
| B5,E5 | B5 | =B3+B4 |
| A6,D6 | A6 | =IF(B6="","","DEPOSIT") |
| B7 | B7 | =B5-B6 |
| E8 | E8 | =E5-E6-E7 |
