Is there a possibility to return truly blank values from Excel custom function?

Question

I am trying to write an Excel custom function that returns a dynamic array containing timestamps and values. In some cases it is possible that a timestamp does not have a value. In this case I would like the value in the dynamic array to be truly blank. I need this because I want to create a graph using the data from the dynamic array, and as long as i return '' or null for an empty cell, Excel interprets it as 0 and the graph does not look correct (I would like the graph to interpolate the data when there is a blank cell)

Answer 1

For custom function, we can't return blank content or NULL. Dynamic array will return 0 for empty cell and it's by design behavior. You may try an empty string as a workaround but it will definitely change the content in the file.