Create an If statement in Excell

[funkjunky]

I need to return an empty cell if there are no figures to calculate. Havnt done this for solong I cant remember how.

 

[DaleWatson123321]

=IF(SUM(A1:A10)=0,"",SUM(A1:A10))

Regards, Dale Watson

 

[funkjunky]

Thanks for that but its not quite there. I think it needs a double if statement.I am using a double entry bookeeping style sheet to show debits and credits on a bank statement with a third column for a running total. I want to copy the formula down the column but not repeat the total all the way down the column.i.e.

Credit Debit Total
150 150
50 100
50 50


It currently looks like this:
Credit Debit Total
150 150
50 100
50 50
50
50
50

 

[Gavona]

In cell C3:
if(count(A3:B3)=0,"",C2+A3-B3)

Thanks,

Gavin

 

[funkjunky]

Eueka!! finally worked out the solution.

=IF(SUM(D4,E4)=0,"",SUM(F3+D4-E4))

Thanks for everyones help.

Funk

 

[KenWright]

No need for the SUMs

=IF((D4+E4)=0,"",F3+D4-E4)

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------