| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to read a blank cell as zero for formulas? | Excel Discussion (Misc queries) | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
| How do identify a blank cell in a formula | Excel Discussion (Misc queries) | |||
| conditional formatting blank cell | Excel Discussion (Misc queries) | |||
| In excel and a pivot table - how can I stop it displaying (blank). | Excel Discussion (Misc queries) | |||
Threaded Mode
