I would be grateful for some help please.
I use an IF function to write a "1" in the cell:
=IF($C$15>$A20,IF($C$15<$A22,1,0),0)
I wish to retain the "1" in the cell once the condition has reverted. I don't want it to go back to "0".
Everything I have tried ends up as a circular reference.
Bookmarks