Nested 'IF' formula to calculate percentage differences of values in a Column

[Stripez3]

=IFERROR(IF(C2="","0",IF(C2+C3>3,1-(C3/C2),IF(C2+C4>3,1-(C4/C2),IF(C2+C5>3,1-(C5/C2),IF(C2+C6>3,1-(C6/C2),IF(C2+C7>3,1-(C7/C2))))))),"0")

- My current formula does not fully work as I want. I tried nested IF statements but there has to be a better way or corrections to make this formula work as I need.

- I need the formula to first check the current cell "C2" of Column C and see if it is empty. This functions currently works in the formula.

- If the cell is empty it will return a "0".

- If the cell "C2" in Column C has a value it will look to the next cell below "C3" and give the percentage difference between the two values "E2" Column E.

- Currently in the formula entering a value in the first two cells everything works, but if you put a value in the first cell and the third cell it does not work.

- I need help with the formula to take the first value and any other value in Column C and give the percentage difference between the two values.

- As an example looking at the current Column C the formula will not add up the percentages of the first and third values.

<tbody>
</tbody>

-Link to excel sheet

 

[Stripez3]

Scott and Skywriter... both your formulas worked like a dream. Have applied both in different workbooks for different reasons and I want to thank you both!
The count formula was just wanted I needed to reduce the formula length and the the nested formula worked for other cells that I did not want to include in some specific workbooks.

Kevin