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.
|