Displaying output

R

recklaw

Is there a way I can restrict excell from displaying an output only if
some information is entered?

E.G. If in cell C1 I enter a formula IF(A1=B1,True,FALSE)

C1 will always display True if A1 and B1 are empty.
I only want C1 to display if there are entries to A1 & B1

Thanks in advance
 
G

Guest

Hi

Try something like this:
=IF(AND(ISBLANK(A1),ISBLANK(B1)),"",IF(A1=B1,True,FALSE))

Andy
 
Top