I'm wanting to check for blank cells, and when the cell is not blank, output a formula. However, I am getting errors and I believe you're not allowed to use formulas within an IF function, are you guys able to help me out?
=IF(A1="","",=lastModified(A1))
If the cell is not empty, this formula will return the date the cell was last modified. I do not want the date updated if the cell is blank.
Thanks for the help.
Aucun commentaire:
Enregistrer un commentaire