Function with if function in it does not work

[vp_10]

Dear users, yet another relatively easy question i think.
I want to perform a very easy calculation, but i don't want that the calculation gets made if there is a 0 value within in. There are two values who are the main inputs if 1 of those 2 equal zero i don't want the calculation to be made, or when they are both zero.
So far i came up with the following:=IF(OR(API167=0,API186=0),0,API167-API186)/(API167+API186)/2 that only works if one of the two values is zero.

Next question is that i want to sum up the row with the values calculated with the formula above, disregarding the zero values. This sum function must be devided by the amount of values which are used as input(so disregarding the zero's)

Can someone help me please?!
Thank you in advance

[Ace_XL]

You need AND() not OR()

=IF(AND(API167=0,API186=0),0,API167-API186)/(API167+API186)/2

Next question is that i want to sum up the row with the values calculated with the formula above, disregarding the zero values. This sum function must be devided by the amount of values which are used as input(so disregarding the zero's)

Try the AVERAGEIF function
=AVERAGEIF(Range_of_data,"<>0")

[vp_10]

thank you very much for your fast reply, it worked! I only needed to add brackets to the second part of the calculation otherwise it would turn up #DIV/0!
Thanks so much for your fast help