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..

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


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

Thanks Mark!!

works great.....