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 |