stop formulas being lost if msquery result has no rows

[jmacleary]

Hello folks.

Hopefully quite simple. I have a spreadsheet which has a table with an associated query, and some calculated columns. The query properties are set to'overwrite existing cells with new data, clear unused cells'.

The problem is that when the query returns 0 rows, the calulated formulae are lost. Is there a way to keep those formulae from being lost?

Thanks in advance

 

[GraH]

My formula got "saved" when using these settings.

 

[jmacleary]

Hi GraH. Thank you very much. You are right. I confused myself and decided I needed to change that to the third option - then was too convinced to even try your answer - Duh!