First time posting...
GOAL:
- I have a column of data (multiple choice test answers). At the top is a calculation based on entries in the cells below. I want it to calculate if and only if the cells are not all blank.
- The formula I'm using in cell E4: =IF(E5:E104="","",(A*B + C*D)) where A,B,C and D represent some other calculated values. .
PURPOSE:
- On the test, if a kid skips the first question but answers others, I want it to calculate the grade, but if the kid didn't take the test at all, I don't want a 0 contributing to the class average.
PROBLEM:
- E4 goes blank only when E5 is blank. I only want E4 to be blank if every cell in the range E5:E104 is blank. I tried it as both an array and non-array formula, but the problem persists.
SOLUTION?
Bookmarks