I'm using the average of column A to multiply by all of my column B inputs to get column C answers. Excel is saying that I have created a circular reference? This is my formula:
=$A$1*B2
This doesn't seem difficult but apparently I'm missing something. Column B is the sum of a few other columns but none of which are A, B, or C.
Bookmarks