First thoughts .. pl remove the caps lock, it's difficult to read

If you mean return a null string ("") if D3 is blank
you could put it like this in say, E3: =IF(ISBLANK($D3),"",D3)

If you mean return a null string ("") if D3 is either blank or contains zero
you could use in E3: =IF($D30,D3,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GEORGE ZEIGLER, SAN DIEGO" wrote:
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.