Manolocs
Active Member
- Joined
- Mar 28, 2008
- Messages
- 340
Columns A, B and C have search formula to find in a table the element in B1.
column D is a simple add/subtract formula.
Problem when the row is empty "", the formula got Error.
Is there a way to use this formula and skip the empty row and preserve the last balance?
Thanks in advance.
<tbody>
</tbody>
column D is a simple add/subtract formula.
Problem when the row is empty "", the formula got Error.
Is there a way to use this formula and skip the empty row and preserve the last balance?
Thanks in advance.
A | B | C | D | ERROR | |
1 | Select Product = | pen | |||
2 | |||||
3 | Product | Amount | Tax | Balance | |
4 | 0 | ||||
5 | pen | 10 | .10 | =d2+B3-C3 | |
6 | =d3+B4-C4 | #VALUE] | |||
7 | pen | =d4+B5-C5 | #VALUE] | ||
8 | #VALUE] | ||||
9 | pen | #VALUE] | |||
10 | #VALUE] | ||||
11 | #VALUE] | ||||
12 | pen |
<tbody>
</tbody>