I have the formula:
=IF(Q5=time(0,0,0),1,0) in cell A3.
It works fine, but I need to "cut" and paste the contents on Q5 elsewhere and then Google Sheets "updates" the formula changing Q5 for the new cell.
I do not want that to happen. I want Google Sheets to maintain Q5 on the original formula! How does the formula need to look like?