Mahsun23Hi there,
Is it possible to make an IF formula where the value of the cell is linked to another cell if TRUE, but the value doesn't change anymore if FALSE. In other words the cell should keep the latest value if FALSE.
Regards
Mahsun
This is not possible with a standard Excel formula. It is possible with VBA if you want to go down that road. I am about to sign off for now but I will have a look tomorrow to see if you are needing more help."In W8 if C8 is not equal to U8 you want whatever was already in W8"
Exactly !!!
Do I want something impossible?
regards