If worksheet function

[Guest]

Is it possibly to have the if worksheet function return an actual blank and not a blank text string ?

 

[Bernie Deitrick]

Dave,

An "actual blank" would mean no formula, so, in a word, No.

HTH,
Bernie
MS Excel MVP

Is it possibly to have the if worksheet function return an actual blank

and not a blank text string ?

 

[Frank Kabel]

Hi
the best you can achieve is
=IF(A1=1,"","something else")

No chance to returna TRUE blank cell with this function

--
Regards
Frank Kabel
Frankfurt, Germany

Is it possibly to have the if worksheet function return an actual

blank and not a blank text string ?

 

[Guest]

Bernie,

Thanks for the info

My if statement chooses a number or a blank string "". The blank string is copied and pasted as a value in another worksheet and then used in a chart. The chart still sees this cell as a value and plots it as 0. Do you have any suggestions on how to get around this so the chart sees these as true blanks and does not plot them

Regard
Dav

----- Bernie Deitrick wrote: ----

Dave

An "actual blank" would mean no formula, so, in a word, No

HTH
Berni
MS Excel MV

Is it possibly to have the if worksheet function return an actual blan

and not a blank text string

 

[Peo Sjoblom]

There is a workaround using the NA function

=IF(A1>1,A1,NA())

would be an example Of course they will return #N/A instead of "blank" cells
but you can
use conditional formatting and formula is =ISNA(Cell) then use a white font

--

Regards,

Peo Sjoblom

Bernie,

Thanks for the info.

My if statement chooses a number or a blank string "". The blank string

is copied and pasted as a value in another worksheet and then used in a
chart. The chart still sees this cell as a value and plots it as 0. Do you
have any suggestions on how to get around this so the chart sees these as
true blanks and does not plot them.