Every cell (from 1 to...) in column d has the AVG formula, which means the result of averaging column c fills all empty cells in column d after the actual result> Sounds confusing.
If cell c2=40 and c3=38, cell d3 will =39. All cells after d3 will =39 until a new value is entered in cell c4 and the formula in d4 will recalculate the average of c2:c4.
What I want to do is keep the formulas in each cell in column d, but if there is no value in c4, the formula in d will return 0 until a value is entered in c4, etc.
How to do that if it is possible?
Edit: Changed subject, was AVG=0 IF..... Make your post understandable by others -- MrProgrammer, forum moderator |