I'm getting a circular reference error with this in Cell if statement. Can someone see if they can clean it up for me?
=IF('Shot Diagram '!G7='Shot Diagram '!$B$14,'Shot Diagram '!G6+'Shot Diagram '!$R$61:$S$61,IF('Shot Diagram '!G7='Shot Diagram '!$B$15,'Shot Diagram '!G6+'Shot Diagram '!$R$61:$S$61,IF('Shot Diagram '!G7='Shot Diagram '!$B$16,'Shot Diagram '!G6+'Shot Diagram '!$T$61:$U$61,IF('Shot Diagram '!G7='Shot Diagram '!$B$17,AND(Sheet2!C7='Shot Diagram '!G6+'Shot Diagram '!$V$64:$W$64,Sheet2!C8='Shot Diagram '!G6+'Shot Diagram '!$V$65:$W$65,Sheet2!C9='Shot Diagram '!G6+'Shot Diagram '!$V$66:$W$66,Sheet2!C10='Shot Diagram '!G6+'Shot Diagram '!$V$67:$W$67),IF('Shot Diagram '!G6='Shot Diagram '!$B$18,AND(Sheet2!C7='Shot Diagram '!G6+'Shot Diagram '!$Y$64:$Z$64,Sheet2!C9='Shot Diagram '!G6+'Shot Diagram '!$Y$65:$Z$65,Sheet2!C10='Shot Diagram '!G6+'Shot Diagram '!$Y$66:$Z$66,Sheet2!C11='Shot Diagram '!G6+'Shot Diagram '!$Y$67:$Z$67),)))))
Thanks,
Bookmarks