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
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
DanielCo
KK avait énoncé :
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
Hello, you have a dedicated italian Excel forum here : http://social.answers.microsoft.com/Forums/it-IT/officeexcelit/threads Regards. Daniel
KK avait énoncé :
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
Hello,
you have a dedicated italian Excel forum here :
http://social.answers.microsoft.com/Forums/it-IT/officeexcelit/threads
Regards.
Daniel
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
Hello, you have a dedicated italian Excel forum here : http://social.answers.microsoft.com/Forums/it-IT/officeexcelit/threads Regards. Daniel
DanielCo
Please, give sample values of V4 and W4 with the expected result. Daniel
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
Please, give sample values of V4 and W4 with the expected result.
Daniel
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
Please, give sample values of V4 and W4 with the expected result. Daniel
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
news.free.fr
Maybe : =SE(W5>0;MEDIA(U5;W5);SE(E(VALVUOTO(W5);V5>0);MEDIA(U5;V5);SE(E(VALVUOTO(V5);VALVUOTO(W5));"";0))) Daniel
Maybe :
=SE(W5>0;MEDIA(U5;W5);SE(E(VALVUOTO(W5);V5>0);MEDIA(U5;V5);SE(E(VALVUOTO(V5);VALVUOTO(W5));"";0)))
Daniel