This is the formula you posted

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

that looks liek a space to me.
Regardless, format the the cell with the formula as general or number, then
whil still selected do editreplace, replace = with =, that sometimes help to
get excel to calculate the formula as opposed to just displaying it

Regards,

Peo Sjoblom

"RTP" wrote:

I now have ""...no space....however that did not fix it.

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

Does the format of cell 'Prospect Questions'!B61 have to be text as well as
the cell in which I have the formula above???


"Peo Sjoblom" wrote:

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!