Use the same approach:
=IF(OR((A2="0"),(B2="0"),(A2=""),(B2=""),(C1="0"), (C1="")),"",C1-A2+B2)

The key is to test ALL of the values that you need. If ANY are zero or
missing, then return blank
--
Gary''s Student - gsnu200769


"Dobbin0_4" wrote:

Ok so I got the formula you gave me working. But there is a small problem i
am trying to use data from the cell above in my formula. so it looks like
this:

=c1-b2+a2

working with the formula you suggested is ok till i add "c1" to the formula
like the example below:

=IF(OR((A1="0"),(B1="0")),"",C1-A1+B1)

Because the data in cell c1 is copied down and i am back to where i started!
:(

anyone else who can help with this. I would be grateful or if Gary Student
has any other ideas , again thanks

"Gary''s Student" wrote:

Hide them with blanks:

Say we are entering numbers in column A & B
In column C we have:

=A1+B1 and copied down. For rows that have no values in A or B, column C
shows 0. If we want C to be blank if either A or B is blank, then:

=IF(OR((A1=""),(B1="")),"",A1+B1)
--
Gary''s Student - gsnu200767


"Dobbin0_4" wrote:

I am seting up a spreadsheet that works like a bank statement, So from
ranges g 6 through g29 i have a balance figure. But i will be adding
transactions to this as i go along through the month. So in cell G7 i have
the formula:
=SUM(G8-F9+E9) and that is then dragged down so htat all the cells to g29
contain this formula.

However they all show the data in the cell above it i.e. cell g8 shows the
amount in g7 and so on. Is there a way to hide this data until i need to
fill the cell with new data?

I hope that you undertand the question its a bit drawn out, and maybe
confusing, if so i apologise.

Thanks in advance