View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Empty Cell Result

No. Formulae always return values to their calling cells.

You could replace the formulas with an Event Macro.

Or there may be alternatives, depending on what you're using the results
for.


In article ,
Mike H. wrote:

In this if statement: IF(A1=100,1,"") I would like the 3rd parameter to not
return "", not return 0 but return NOTHING. Is there a way to return empty,
blank, etc?