If /T hen?

Posted by Anthony on July 09, 2001 9:32 AM

Hello to all! I have a column that keeps a running total. If a zero is entered into the column, how would I return the value of zero instead of the formula carrying down the previous total?

e.g.

if I have 100 + 200 + 300 this means that I started with 100, then an additional 100 was entered to bring me to 200 along with the same which gave me 300. Now if I add a zero in order to obtain the fourth total, I want it to read "0" and not 300. Hope I'm making sense. Is there an If'Then statement that can help me with this?

Regards

Anthony

Posted by Barrie Davidson on July 09, 2001 9:38 AM

Anthony, it sounds to me like you are keeping a running total until a zero is entered. If that is the case, and assuming your data is entered in column A and your running total is in column B, try the following formula (in B2):

=IF(A2=0,0,B1+A2)

Regards,
Barrie

Posted by Anthony on July 09, 2001 2:30 PM

Worked Perfect! Thank You!