Displaying a blank cell
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!
|