static time with if function

R

raghav

I want the time updated when a cell is not blank, i tried with
=if(a1="","",now())), but the time is keep changing. can someone help??
 
M

MikeJohnB

What do you mean, the time keeps changing? The time will remain constant
until the value in cell A1 is changed. The time will then be updated, is that
what you mean?

Regards
 
Top