MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Circular Reference


Posted by Patrick on June 04, 2001 6:22 AM

I have this formula that is a circular reference
the formula is in B2
as you can see, I am trying to compare Sheet2!I1
against Sheet2!A1. If sheet2!I1 is greater show
that figure if it is less show nothing..

=IF(Sheet2!I1>Sheet2!A1,Sheet2!I1)+IF(B2=FALSE,"")
how else can I write this to do what i want but not be
a circular reference
thanks in advance


Posted by Mark W. on June 04, 2001 6:33 AM

=IF(Sheet2!I1>Sheet2!A1,Sheet2!I1,"")

Posted by Patrick on June 04, 2001 6:58 AM

Thanks Mark!!

works great.....