View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GEORGE ZEIGLER, SAN DIEGO GEORGE ZEIGLER, SAN DIEGO is offline
external usenet poster
 
Posts: 1
Default WANT TO MAKE A FORMULA RETURN A BLANK CELL (VS 0)

I have tried every method I can think of to return a blank cell as the result
of a formula

EXAMPLES:
IF($D31,D3,"") HOPING "" COULD BE INTERPRETED AS EMPTY STRING (BLANK
IF($D31,D3,A2) WHERE A2 IS A BLANK CELL

NO MATTER WHAT I TRY, XL AWAYS RETURNS 0'S ... THIS DOESN'T WORK FOR MY
APPLICATION. I CAN'T SEEM TO FIND A WAY TO HAVE A FORMULA RETURN A BLANK
CELL.

ANY HELP IS GREATLY APPRECIATED !!!

THANKS ... GEORGE ZEIGLER, SAN DIEGO.