If Statemnt - Volatile result

Question

I am doing Conditional Formatting on a date field. For 1 data set it works fine. When I try it on another data set it is not working.

When testing the IF statement, it appears that result rather than True or False I get the result Volatile.

Can anyone suggest a fix for this.

Thanks

Richard.

sergeibaklan · Answer

RichardB-257397-242020&nbsp;
Richard, is it possible to receive small sample file or at least screenshot of how it looks?

richardb-257397-242020 · Answer

SergeiBaklan&nbsp;&nbsp;Sergei, Thanks for the reply. Here is a screen shot of the issue. I have highlighted in the Formula dialogue box the issue.&nbsp;&nbsp;

sergeibaklan · Answer

RichardB-257397-242020&nbsp;
Richard, I see, thank you for the screenshot. That's not an error, that's kind of alert which says you use so called volatile functions. In this case that is TODAY(). Excel recalculate all volatile functions with every operation in the sheet, even if such function has no connection to this operation at all. Thus such functions could significantly reduce the performance of all calculations.&nbsp;
&nbsp;
I guess Excel doesn't show result at this very moment for such functions since they are recalculated all the time.
&nbsp;
You may simply ignore this "formula result".

richardb-257397-242020 · Answer

SergeiBaklan&nbsp;Sergei,Thanks for the reply and yes that would explain the "Volatile" result of the formula.&nbsp;What doesn't make any sense is that this functions works perfectly elsewhere on the worksheet.&nbsp;The only difference is that the conditional formatting is on data values that have a hyperlink associated with them this time. On the row that it is working on there are no hyperlinks.&nbsp;ThanksRichard

Forum Discussion

If Statemnt - Volatile result

4 Replies

Resources