How can I get "=TODAY()" results to be non-volatile?

[Guest]

When using "NOW()" or "TODAY()" in an Excel "IF" statement the result is
shown as "Volatile" - and further functions complain that "A value is not
available...."

 

[Guest]

Please give more details........sample formula, what you expect and what
you're getting........

FYI, this works fine in XL97 SR2

=IF(A1>TODAY(),"greater","lesser")

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Hi, what I'm doing is an If statement like =IF($D9+31<TODAY(),$Q9,"") This
actually works fine - BUT - a function that uses the result this IF statement
like =SUM(IF(FREQUENCY(IF(LEN(BG9:BG986)>0,MATCH(BG9:BG986,BG9:BG986,0),""),
IF(LEN(BG9:BG986)>0,MATCH(BG9:BG986,BG9:BG986,0),""))>0,1))
gives this result "#N/A" and only when I remove the "TODAY" or "NOW" part of
the expression will it work!
Hope this makes sense