Hi,
I have searched the forums and net, but cannot get an answer. I am looking for a formula that will make a cell keep the last formula result unless it is changed. I am currently using:
=IF(A6<>'Daily Input'!$B$4,M6,IF(A6='Daily Input'!$B$4,'Daily Input'!$C$8,M6)), but it is not working as...