J
Justin
I'm trying to use the TREND function to predict sales.
I'm getting an error saying the formula has a circular reference. I'm
completely stumped as to why this is. The formula is in cell B7, and as
per my screen shot, I don't refer to B7 anywhere. Why would it be circular?
=TREND(B$2:B$6,A$2:A$6,A7,1)
http://postimage.org/image/iz1ichnk7/
I'm getting an error saying the formula has a circular reference. I'm
completely stumped as to why this is. The formula is in cell B7, and as
per my screen shot, I don't refer to B7 anywhere. Why would it be circular?
=TREND(B$2:B$6,A$2:A$6,A7,1)
http://postimage.org/image/iz1ichnk7/