How to return value_if_false as a blank cell?

[y2gordo]

I am working on a fairly large worksheet, and in the interest of not having a bunch of useless numbers cluttering up the pages, I'm trying to have an "IF" function return as simply a blank cell if the statement is false.

I've tried:

=IF(COUNT(B4:E4)=4,D4-B4," ") This returns as a space within a cell that appears blank. Problem with that is I have a second function elsewhere in the spreadsheet which is adding several cells containing this function, and it's not liking the space.

=IF(COUNT(B4:E4)=4,D4-B4,) This returns "0", which works well in the second function, but doesn't accomplish my goal of having a completely blank cell.

=IF(COUNT(B4:E4)=4,D4-B4) This returns "FALSE", which pretty much works the same as the previous attempt.

=IF(COUNT(B4:E4)=4,D4-B4,IV65536) The referenced cell being one that I know will remain blank no matter how big this things ends up. This returns a "0".

Is there a way I can have the function return a blank cell? Thanks.

///@\\\

[theDude]

Remove the space between the quotes like this:

=IF(COUNT(B4:E4)=4,D4-B4,"")

Hope this helps,
theDude

[y2gordo]

Nope, Excel still treats that as though there was a space between the quotes.

///@\\\