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...."

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

FYI, this works fine in XL97 SR2

=IF(A1TODAY(),"greater","lesser")

Vaya con Dios,
Chuck, CABGx3



"FBC Dave" wrote:

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...."

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:BG 986,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


"CLR" wrote:

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

FYI, this works fine in XL97 SR2

=IF(A1TODAY(),"greater","lesser")

Vaya con Dios,
Chuck, CABGx3



"FBC Dave" wrote:

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...."