**A-B--------C--D
1 X empty 50 50. (because 1st row)
2 Y empty 10 60. (D2=D1+C2 because B2=empty) addition
3 Z 20 empty 40. (D3=D2- B3 because C3=empty) subtraction
please write a formula to continue this conditional addition or subtraction.
**A-B--------C--D
1 X empty 50 50. (because 1st row)
2 Y empty 10 60. (D2=D1+C2 because B2=empty) addition
3 Z 20 empty 40. (D3=D2- B3 because C3=empty) subtraction
please write a formula to continue this conditional addition or subtraction.
Last edited by ranjitbd; 11-29-2010 at 04:56 PM. Reason: positioning
Try this:
Copy D2 down as far as you needPlease Login or Register to view this content.
Does that help?
solved but i want repeat the formula...so every cell i want to press just enter and get the execution of the formula to avoid copy and paste in each cell
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks