Excel 2010 - Accept a volatile function

[Sayth]

How can I force excel 2010 to accept a volatile function. Note I don't need the date Now() to recalculate on reload every time.

The cell just doesn't accept my formula as a formula though its pretty basic. All it does is compare dates in an if.

so on first go I used the now function to compare @[Scheduled Start] which is in this format 9/01/2015 2:00:00 PM to now and return Todo if its greater or Done if its less.

I get no error or result it just sits in the cell as if its text.

=IF([@[Scheduled Start]]>(NOW()),"Todo","Done")

So I created a third column and called it wordate and manually entered a date in the same format and the formula became.

=IF([@[Scheduled Start]]>[@workdate],"Todo","Done")

But still nothing, if I inspect the formula all I get is that I have a volatile result.

 

[Andrew Poulsom]

In what columns are Scheduled Start and workdate and where did you enter your formula? If, when entering a formula, you only see the formula, make sure that the cell is not formatted as Text before entering it. The NOW function is volatile when used in any formula.