| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Blank cell after evaluation
I am using the formula, =IF(ISNUMBER(Analysis!O6),Analysis!O6," ") but have a
problem. If there is a value in Analysis!O6 then the file works properly. However, if Analysis has no value in it, then I need to formula to return nothing. The problem is that I can only get the formula to return a blank space, 0, or False. All of these results cause a subsequent formula to fail. Is there a different formula or criteria that will leave the cell empty? -- Thanks in advance, JC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting Purely BLANK Cell | Excel Worksheet Functions | |||
| Replace null string with blank cell | Excel Discussion (Misc queries) | |||
| Look for change next blank cell in Range | Excel Worksheet Functions | |||
| Go to first blank cell | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
