R
Ron Bernstein
The following formula resides in cell F37.
=IF(A37 = TODAY( ), F30, #N/A)
Right now if A37 is TODAY, then the content of F30 will be
written into F37 (current cell). I want to change the F30
argument to be the previous cell if true "F36".
I can't seem to come up with the correct syntax to write
the value of F30 into F36.
Thanks.
Ron
=IF(A37 = TODAY( ), F30, #N/A)
Right now if A37 is TODAY, then the content of F30 will be
written into F37 (current cell). I want to change the F30
argument to be the previous cell if true "F36".
I can't seem to come up with the correct syntax to write
the value of F30 into F36.
Thanks.
Ron