jeudi 3 novembre 2016

How can I use a formula with an IF function?

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