Displaying a blank cell

[Guest]

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!

 

[Guest]

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

 

[Guest]

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???

 

[Guest]

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 edit>replace, replace = with =, that sometimes help to
get excel to calculate the formula as opposed to just displaying it

Regards,

Peo Sjoblom

 

[Guest]

RTP,

If you want your formula to return the contents of cell 'Prospect
Questions'!B61, shouldn't it say so, instead of asking it to return " ", or
""?

I would use:
=IF('Prospect Questions'!B61>0,'Prospect Questions'!B61,"")

In English: if the contents of 'Prospect Questions'!B61 are more than zero
(and text is that, in Excel), return those contents, if not, return blank. It
worked for me. Your formula returned nothing in my spreadsheet, with or
without the space.

Best wishes.

IanRoy