Have you text format in the cell with the formula? Also,

=IF('Prospect Questions'!B61="","",'Prospect Questions'!B61)

I noticed that you used a space in your formula " " as opposed to "", typo?

Regards,

Peo Sjoblom


"RTP" wrote:

I have this formula in my spreadsheet...

=IF('Prospect Questions'!B61=""," ","")

Obviously, if cell B61 on the Prospect Questions work sheet is blank, I want
this new cell to appear with a blank. Otherwise I want the contents of what's
in B61.

When I enter this formula, it is displaying the formula.

What am I doing wrong??? Is the formatting wrong??? Or just the formula??

HELP!