Is there a formula format, which if condition is not met, leaves the cell unchanged?
Please, share an example of what do you need. Thanks.
Hi
Thanks for following this up.
I want to have a figure, say 160, in C3 which is automatically replicated in C7,C13,C19 etc
Then if I change the 160, could be up or down, it will change future months but not past ones.
I’ve played about with TODAY() but got nowhere. As you can tell, I’m no expert !!
Cheers
Try the following formula in D3 and drag down
=IF(ISBLANK($C3);D2;$C3)Nother way:
- Select C4:C23 (starting below the first cell) with input focus on C4
- Copy the selection
- Keep the selection, type =C3, confirm with ALT+Enter
- Paste-special [Ctrl+Shift+V], paste “All” with option “Skip empty cells”.
I’m not clear how these relate to date i.e. if I change C3 today, I want it to update C13 & C19 but not C7.
Data>Validity…
In version 7.1.8.1, Validity is for typed content (not pasted content, nor formulas).