Setting Cell equal to blank

[wiscokid]

I have an if statement, that if true, I would like the cell to be left blank (not " ", but blank), otherwise the if statement will return a value.

Does anyone know how to set a cell = blank in an if statament?

thanks in advance

 

[Norie]

What exactly do you mean by blank?

The "" is an empty string, is that what you don't want?

 

[ezakovich_35]

blank cells

in your request, you have a space between the quotation marks. if you want a blank cell, you get rid of the space. the cell isn't blank per se, in the toolbar you can still see the formula. you can always apply conditional formatting to print a TRUE statement in white and then it would appear to be blank. the help screens in Excel have several options for this.

 

[wiscokid]

The issue I am having is for the following formula:

=IF(D5<0.02,,D5)
this sets the sell = 0.0 if d5<.02

If I use
=IF(D5<0.02," ",D5)
then it makes the cell blank (which I want), but my
conditional formatting makes the cell green
my conditional formatting is:
If cell >.10 then green
If cell between .05 and .10 then blue
if cell between .02 and .05 then yellow

If the cell is less than .02, I would like the cell to be blank and not be formatted (kept white)

any ideas?