Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return an empty or blank cell value?
When I use the IF function in most cases, I want it to either show some text
or nothing at all. I have always performed this function as in the following example: =IF(A1=5,"Five"," ") If A1 is not equal to five, then my cell will show a space which makes it appear to look empty or blank... a cheap fix I suppose. Is there a way to make a cell truly act as if it were completely empty in this case?... without cheating with a " " space or without returning a zero (0)? Thanks much for any info. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return an EMPTY cell in an IF formula | Excel Discussion (Misc queries) | |||
Vlookup return 0 when cell is blank | Excel Worksheet Functions | |||
use IF to return a truly blank cell | Excel Discussion (Misc queries) | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |