Formula problem

David · Sep 25, 2006

I'm using excel to just added to columns. I don't know the values of the
coulmns yet but obviously i know the formula. How do i input the formula
without the result showing as zero before the data has been input.

Bob Umlas · Sep 25, 2006

Tools/Options/View; deselect "Zero Values"

Don Guillett · Sep 25, 2006

=if(a1="","",myformula)

Gord Dibben · Sep 25, 2006

David

=IF(AND(A1="",B1=""),"",A1+B1)

Gord Dibben MS Excel MVP

Formula problem

David

Bob Umlas

Don Guillett

Gord Dibben