A function to populate another cell
A function to populate another cell. Something like;
IF(a1<>0,LET a5=a1,LETa5="") as a function in any cell other than a1 or a5
This populates a5 if the condition is met but enables a value to be typed into a5 without overwriting a formula.
As far as I know, this can only be done today with VBA. This would be so useful to me.