IF statement not working anymore

[thundardog]

I have been using the IF statement below to time an date stamp a field when a value is entered in the adjacent field

=IF(C4="","",IF(B4="",NOW(),B4))

I now get a circular reference error when I open the file, which I never got before and now it does not complete the NOW() statement.

any thoughts???

 

[SteveO59L]

Which cell holds the formula?

 

[thundardog]

In my example B4 holds the formula

 

[SteveO59L]

errrrrrrr, thats why you get a circular reference

 

[thundardog]

Issue is I have been using it for months, no problems

 

[SteveO59L]

Perhaps for months C4 wasnt blank ?

 

[thundardog]

I add a value into C4 and B4 will populate with the time and date stamp at the same time.

 

[thundardog]

That is what it is suppose to do (is the date and time correct?), do you think it could be a format issue, or something else.

 

[SteveO59L]

If in a formula, you refer to the cell the formula is in, that is a circular reference.

In your example, the formula is in B4, and you refer to cell B4.