If/then

[preciousjeni]

Greetings, helpful people!

My formula is written as follows:

=(SUM((I4/35)+(IF(I17 = 0, 0, (I17/35)))))

What I'm trying to do is to add the averages from two rows of numbers (each row separately adding up to a total of 35 points) to get a final average.

The catch is that one row of numbers is required to be filled in by the user while the other row is not, so I want it to determine whether to use a zero or to take the total from the row and divide it by 35.

I4 is the row the users must enter values into.

I17 is the row that could either result in a zero or in a set of values.

I'll try to explain my formula in regular language to make it clearer:

This cell is the sum of I4 divided by 35 PLUS I17 (which should be ZERO if no values are entered OR I17 divided by 35 if values are entered).

Please help!!

[preciousjeni]

Nevermind! I figured out what I was doing wrong. It kept adding up to 200%. The solution is:

=(IF(I17 = 0, I4/35, (I4+I17)/70))