HELP

[KK]

Hi i am italian
I need help with this
=SE(CONTA.NUMERI(V4;W4);SE(O(W4=0;V4=0);0;ARROTONDA.PER.DIF(MEDIA(U4;SE((W4<>"");W4;V4));0));"")

The first part says that "If there is a number in V4 or W4"
The third part says That it has to do an average between U4 and W4 if there
is W4, and if no with V4 (if there aren't W4 nor V4, no has to make an
average)
The second part in bold is the problem
I want If W4 priority is 0, and if there isn't W4, if V4 is 0, so the result
has to be 0
If There is a number in V4, but W4 is 0, the result has to be 0
W4 has to be priority respect then V4
Thanks

 

[Stan Brown]

Hi i am italian
I need help with this
=SE(CONTA.NUMERI(V4;W4);SE(O(W4=0;V4=0);0;ARROTONDA.PER.DIF(MEDIA(U4;SE((W4<>"");W4;V4));0));"")

The first part says that "If there is a number in V4 or W4"
The third part says That it has to do an average between U4 and W4 if there
is W4, and if no with V4 (if there aren't W4 nor V4, no has to make an
average)
The second part in bold is the problem
I want If W4 priority is 0, and if there isn't W4, if V4 is 0, so the result
has to be 0
If There is a number in V4, but W4 is 0, the result has to be 0
W4 has to be priority respect then V4
Thanks

You say you need help, but you don't say what the problem is.

My suggestion is this: break the formula into several formulas, and
then it will be easier to find your mistake.

You could also do Formulas » Formula Auditing » Evaluate Formula
(sorry, I don't know the Excel menus in Italian). That will evaluate
the formula piece by piece, which might help you.

 

[KK]

I have
U5 fixed value
X5 results
V5 and W5 numers that I insert

if there are both V5 and W5, average between U5 and W5 (always priority for
W5):
U5 V5 W5 X5
2 4 6 4

If there is only W5, average between U5 and W5
U5 V5 W5 X5
2 6 4

If there is only V5, average between U5 and V5
U5 V5 W5 X5
2 4 3

If there aren't both, NO average, NO write 0:
U5 V5 W5 X5
2

If V5=0 and nothing in W5, X5=0
U5 V5 W5 X5
2 0 0

If W5=0 and nothing in V5, X5=0
U5 V5 W5 X5
2 0 0

If V5=0 and W5=0, in X5=0
U5 V5 W5 X5
2 0 0 0

If V5=0, but there is a number in W5, average between U5 and W5:
U5 V5 W5 X5
2 0 6 4

If W5=0, X5=0
U5 V5 W5 X5
2 4 0 0

or

U5 V5 W5 X5
2 0 0

Quindi in pratica la media di U5 con:
Se ci sono sia V5 che W5, allora con W5
Se c'è solo W5 , allora con W5
Se c'è solo V5, allora con V5
Se non c'è nè V5 nè W5 niente media
Se V5=0 e non c'è nulla in W5, allora a prescindere da U5, in X5 ci sarà 0
Se V5=0 e W5=0 allora in X5 ci sarà 0 a prescindere da U5
Se V5=0 e c'è numero in W5 allora in X5 media di U5 con W5
Se W5=0, in X5 ci sarà 0 a prescindere da cosa c'è in V5 e in U5 (quindi sia
se in V5 ci sia un numero, se non ci sia nulla o se V5=0)