How to make a cell truly BLANK

[kkjensen]

Hello all.

I'm trying to set up an if statement that will either show a value or leave the cell blank. "Blank" meaning I can copy a range and do a Paste Special -> Values & Skip Blanks and not have this cell overwritting other information.

Here's what I currently have but the double quotes "" are not being treated as a blank.

=IF(A3=B3,"",C3)


HELLLLP ray:

 

[Mark W.]

An Excel formula always returns something (text, number, logical value...) and; therefore, cannot produce an empty cell.

 

[kkjensen]

Is there a way to copy and paste every cell that is not ""? Skipping "" instead of skipping blanks.

 

[Nimrod]

Use Goto Special Cells...

1. Press F5
2. In "goto" window click on "special.."
3. In Special window indicate you want cells with formula showing numbers

... this will highlight cells with formula that are showing numbers...


Here's what the Excel help says about this...

Select the range that includes the type of cells you want to select.
To select all cells of this type on the active worksheet, click any cell.

On the Edit menu, click Go To.
Show Me

Click Special.


Click Formulas, and then select the check box next to the type of data you want to select.
Note You can also select a range that contains an array formula.