Hi!
Recently I came across this problem and I'm sure there must be a clever solution to it:
I have a range of cells (A1:A1001) that are each target cells for different elements of a user input form (little boxes to check, etc).
In case of missing values (i.e., the user forgets to check a box), I want to insert the average of all values in the range in that empty cell.
Problem: I will have a circular reference if using a function such as if(A1=0,"insert mean A1:1001",A1).
I'm sure there is a way of achieving this in Excel (must be a common problem). Can anyone help?
Thanks!
as
Bookmarks