Hi and sorry if that Title isn't clear.
I need a formula (I think probably in the IF/OR area?) whereby the result in one cell (C3) is the result of multiplying two other cells (C2 x B3) - simple right?
What I need though is to not do the calculation if C2 is 0, rather to just insert the value of B3.
So in the attached I need C7 to be 2 and C8 to be 6 etc, i.e. start the running total again after a 0 entry
Thanks
blue
Bookmarks