Why can't I get the average function work with empty cells?
Views
Replies
Total Likes
because it is doing a division by 0 which is invalid. Just put in an if statement that only does the calculation is the field is not null.
Views
Replies
Total Likes
The thing that I am having a problem with is that I made a different form that calculates the average no matter how may of the cells have numbers or not and I didn't use an if function. I have tried with this other form and and it calulates as if all the cells where being used. I am using the [*] in both instances but it only works in the one I did earlier.
Views
Replies
Total Likes