Return blank cell from IF()

J

JM

Is there a way to return a blank cell from a function
like IF()? I realize that returning "" is not the same
as returning a blank as charts don't interpret them the
same. Also, returning NA() is not an option because
doing so causes problems with other function calls based
on this column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Excel does not accept text format! 0
Excel Logical function 5
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
VLOOKUP text vs number issues returning value 13
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can UDF return a customized hyperlink? 3
INDEX return multiple columns 1

Top