If worksheet function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

HTH,
Bernie
MS Excel MVP

Dave said:
Is it possibly to have the if worksheet function return an actual blank
Click to expand...
and not a blank text string ?
 
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

Dave said:
Is it possibly to have the if worksheet function return an actual
Click to expand...
blank and not a blank text string ?
 
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

Dave said:
Is it possibly to have the if worksheet function return an actual blan
Click to expand...
and not a blank text string
 
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

Dave said:
Bernie,

Thanks for the info.

My if statement chooses a number or a blank string "". The blank string
Click to expand...
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.
 
Back
Top