hi,
I have the following issue with circular reference.I have enabled circular reference in formula settings with max iteration=1
but still (if) condition produces wrong result.i have given the formula in "c2". C2 VALUE IS 98 and D2 VALUE IS 63.65.The condition is actually not met.But still formula produces as "ACHIEVED".
=IF(C2="ACHIEVED","ACHIEVED",IF(C2<D2,"ACHIEVED","")
Can anybody help on this issue?
regards,
Netaji
Bookmarks