Oh for the circular.. please set Iteration to... maybe 10?
Tools > Options > Calculations tab > Iteration check box & value to 10
Edit: Sorry, also pls change formula in Cell E9 to
=IF(OR(H9=3,E10=3),1,IF(AND(F9+G9<H9,E7+E8<E10),1,0))
Oh for the circular.. please set Iteration to... maybe 10?
Tools > Options > Calculations tab > Iteration check box & value to 10
Edit: Sorry, also pls change formula in Cell E9 to
=IF(OR(H9=3,E10=3),1,IF(AND(F9+G9<H9,E7+E8<E10),1,0))
Last edited by SCLai; 05-09-2012 at 01:33 AM.
Do give a * (bottom left) if the post helped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks