Félicitations !
+
0
points
En savoir plus
Actualités
Tests & Guides
Bons Plans
Forum
Premium
Rechercher sur le site
Connexion
Si votre email correspond à un compte, vous recevrez un lien de réinitialisation.
Réinitialiser le mot de passe
Retour connexion
Actualités
Tests & Guides
Bons Plans
Twitter
iPhone pliant
OnePlus 11
PS5
Disney+
Orange Livebox
Windows 11
Génération NT
Entraide
Applications
Microsoft Office
Excel
formule en vba
formule en vba
22 réponses
magic-dd
19/03/2008 à 22:49
bonsoir
j'ai un classeur avec 18 feuilles structur=E9es de la meme facon
dans des memes cellules de x6 =E0 x38 j'ai cette formule
=3DSI(NBCAR(B6)=3D0;"";(SOMME(D6:H6)*20)/25)
en changeant le b6 par "b" & i, d6 par "d" & i et "h" & i
ensuite j'ai une matricielle
de z6 =E0 z38
{=3DSI(OU(NBCAR(B6)=3D0;NB(N6:T6)=3D0);"";SOMME(SI(ESTNUM(N6:T6);N6:T6*$N
$5:$T$5))/SOMME.SI(N6:T6;">=3D0";$N$5:$T$5))}
la aussi tout ce qui n'est pas entre les $ peut etre fais avec la
valeur "b" & i etc.....
merci de votre aide ca permettra de rendre plus rapide mon programme
et surtout moins lourd.
@bientot
Partager
Facebook
Twitter
Reddit
Whatsapp
Email
Signaler
Signaler un problème avec ce contenu
Envoyer
2 réponses
Supprimer
Cette action est irreversible, confirmez la suppression du commentaire ?
Supprimer
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Envoyer
1
2
3
magic-dd
Signaler
27/03/2008 à 21:10
Bravo !!!!!!!!!!!!!
tout est parfait
je t'offre ce beau papillon qui montre que d'une chrysalide de projet
on arrive toujours à réaliser l'envol que l'on souhaite
merci beaucoup isabelle
_______
LLLLLLLLLLL
__LLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLL
_LLLLLLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLL
_LLLLLLLLLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLLLL
L
_LLLLLLLLLLLLLLLLLLLLLLL
LL
LLLLLL~~~LLLLLLLLLLLLLL
_L _LLLLL
LLLLLLLLLLLLL
L~ LLL~
LLLLLLLLLLLLL
LL _LLL _LL
LLLLLLLL
LL LL~ ~~
~LLLLLL
L _LLL_LLLL___
_LLLLLL
LL LLLLLLLLLLLLLL
LLLLLLLL
L LLLLLLLLLLLLLLL
LLLLLL
LL LLLLLLLLLLLLLLLL
LLLLL~
LLLLLLLL_______ L _LLLLLLLLLLLLLLLL
LLLLLLLL
~~~~~~~LLLLLLLLLLLLLLLLLLLLLLLLL~
LLLLLL
______________LLL LLLLLLLLLLLLLL
______LLLLLLLLL_
LLLLLLLLLLLLLLLLLLLL LLLLLLLL~~LLLLLLL~~~~~~
~LLLLLL
___LLLLLLLLLL __LLLLLLLLLLLLL LLLLLLLLLLLLL____
_LLLLLL_
LLLLLLLLLLL~~ LLLLLLLLLLLLLLL LLLLLLLLLLLLLLLLLL
~~~LLLLL
__LLLLLLLLLLL _LLLLLLLLLLLLLLLLL_ LLLLLLLLLLLLLLLLLL_
LLLLL
LLLLLLLLLLL~ LLLLLLLLLLLLLLLLLLL ~L ~~LLLLLLLLLLLLL
LLLLLL
_LLLLLLLLLLLL LLLLLLLLLLLLLLLLLLLLL_ LL LLLLLLLLL
LLLLLLLLL
LLLLLLLLLLLLL LLLLLLLLLLLLL~LLLLLL~L LL ~~~~~
~LLLLLL
LLLLLLLLLLLLLLL__L LLLLLLLLLLLL_LLLLLLL LL_ LL_ _
LLLLLL
LLLLLLLLLLLLLLLLL~ ~LLLLLLLL~~LLLLLLLL ~L ~LLLL ~L
LLLLLL~
LLLLLLLLLLLLLLLL _LLLLLLLLLL LL LLLLLLL___
LLLLLLLLLL
LLLLLLLLLLLLLLLL LL~LLLLLLLL~ LL LLLLLLLLLLLL
LLLLLLL~
LLLLLLLLLLLLLLLL_ __L _L LLLLLLLL LLL_
LLLLLLLLLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLL L~ LLLLLLLL
LLLLLLL~LLLLLLLLLLLLLLLL~
LLLLLLLLLLLLLLLLLLLL___L_ LL LLLLLLL LLLL LLLLLLLLLLLLLL
~~LLLLLLLLLLLLLLLLLLLLLLLL LLLLL~ LLLLL ~~~~~~~~~
LLLLLLLLLLLLLLLLLL_ _ LLL _LLLLL
~~~~~~LLLLLLLLLL~ LLLLLL
LLLLL _LLLLLL
LLLLL L L LLLLLLL
LLLLL__LL _L__LLLLLLLL
LLLLLLLLLL LLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLLLL
~LLLLLLLLLLLLLLLLL~~
LLLLLLLLLLLLL
~~~~~~~~~
Bravo !!!!!!!!!!!!!
tout est parfait
je t'offre ce beau papillon qui montre que d'une chrysalide de projet
on arrive toujours à réaliser l'envol que l'on souhaite
merci beaucoup isabelle
_______
LLLLLLLLLLL
__LLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLL
_LLLLLLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLL
_LLLLLLLLLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLLLL
L
_LLLLLLLLLLLLLLLLLLLLLLL
LL
LLLLLL~~~LLLLLLLLLLLLLL
_L _LLLLL
LLLLLLLLLLLLL
L~ LLL~
LLLLLLLLLLLLL
LL _LLL _LL
LLLLLLLL
LL LL~ ~~
~LLLLLL
L _LLL_LLLL___
_LLLLLL
LL LLLLLLLLLLLLLL
LLLLLLLL
L LLLLLLLLLLLLLLL
LLLLLL
LL LLLLLLLLLLLLLLLL
LLLLL~
LLLLLLLL_______ L _LLLLLLLLLLLLLLLL
LLLLLLLL
~~~~~~~LLLLLLLLLLLLLLLLLLLLLLLLL~
LLLLLL
______________LLL LLLLLLLLLLLLLL
______LLLLLLLLL_
LLLLLLLLLLLLLLLLLLLL LLLLLLLL~~LLLLLLL~~~~~~
~LLLLLL
___LLLLLLLLLL __LLLLLLLLLLLLL LLLLLLLLLLLLL____
_LLLLLL_
LLLLLLLLLLL~~ LLLLLLLLLLLLLLL LLLLLLLLLLLLLLLLLL
~~~LLLLL
__LLLLLLLLLLL _LLLLLLLLLLLLLLLLL_ LLLLLLLLLLLLLLLLLL_
LLLLL
LLLLLLLLLLL~ LLLLLLLLLLLLLLLLLLL ~L ~~LLLLLLLLLLLLL
LLLLLL
_LLLLLLLLLLLL LLLLLLLLLLLLLLLLLLLLL_ LL LLLLLLLLL
LLLLLLLLL
LLLLLLLLLLLLL LLLLLLLLLLLLL~LLLLLL~L LL ~~~~~
~LLLLLL
LLLLLLLLLLLLLLL__L LLLLLLLLLLLL_LLLLLLL LL_ LL_ _
LLLLLL
LLLLLLLLLLLLLLLLL~ ~LLLLLLLL~~LLLLLLLL ~L ~LLLL ~L
LLLLLL~
LLLLLLLLLLLLLLLL _LLLLLLLLLL LL LLLLLLL___
LLLLLLLLLL
LLLLLLLLLLLLLLLL LL~LLLLLLLL~ LL LLLLLLLLLLLL
LLLLLLL~
LLLLLLLLLLLLLLLL_ __L _L LLLLLLLL LLL_
LLLLLLLLLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLL L~ LLLLLLLL
LLLLLLL~LLLLLLLLLLLLLLLL~
LLLLLLLLLLLLLLLLLLLL___L_ LL LLLLLLL LLLL LLLLLLLLLLLLLL
~~LLLLLLLLLLLLLLLLLLLLLLLL LLLLL~ LLLLL ~~~~~~~~~
LLLLLLLLLLLLLLLLLL_ _ LLL _LLLLL
~~~~~~LLLLLLLLLL~ LLLLLL
LLLLL _LLLLLL
LLLLL L L LLLLLLL
LLLLL__LL _L__LLLLLLLL
LLLLLLLLLL LLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLLLL
~LLLLLLLLLLLLLLLLL~~
LLLLLLLLLLLLL
~~~~~~~~~
Vous avez filtré cet utilisateur ! Consultez son message
Bravo !!!!!!!!!!!!!
tout est parfait
je t'offre ce beau papillon qui montre que d'une chrysalide de projet
on arrive toujours à réaliser l'envol que l'on souhaite
merci beaucoup isabelle
_______
LLLLLLLLLLL
__LLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLL
_LLLLLLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLL
_LLLLLLLLLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLLLL
L
_LLLLLLLLLLLLLLLLLLLLLLL
LL
LLLLLL~~~LLLLLLLLLLLLLL
_L _LLLLL
LLLLLLLLLLLLL
L~ LLL~
LLLLLLLLLLLLL
LL _LLL _LL
LLLLLLLL
LL LL~ ~~
~LLLLLL
L _LLL_LLLL___
_LLLLLL
LL LLLLLLLLLLLLLL
LLLLLLLL
L LLLLLLLLLLLLLLL
LLLLLL
LL LLLLLLLLLLLLLLLL
LLLLL~
LLLLLLLL_______ L _LLLLLLLLLLLLLLLL
LLLLLLLL
~~~~~~~LLLLLLLLLLLLLLLLLLLLLLLLL~
LLLLLL
______________LLL LLLLLLLLLLLLLL
______LLLLLLLLL_
LLLLLLLLLLLLLLLLLLLL LLLLLLLL~~LLLLLLL~~~~~~
~LLLLLL
___LLLLLLLLLL __LLLLLLLLLLLLL LLLLLLLLLLLLL____
_LLLLLL_
LLLLLLLLLLL~~ LLLLLLLLLLLLLLL LLLLLLLLLLLLLLLLLL
~~~LLLLL
__LLLLLLLLLLL _LLLLLLLLLLLLLLLLL_ LLLLLLLLLLLLLLLLLL_
LLLLL
LLLLLLLLLLL~ LLLLLLLLLLLLLLLLLLL ~L ~~LLLLLLLLLLLLL
LLLLLL
_LLLLLLLLLLLL LLLLLLLLLLLLLLLLLLLLL_ LL LLLLLLLLL
LLLLLLLLL
LLLLLLLLLLLLL LLLLLLLLLLLLL~LLLLLL~L LL ~~~~~
~LLLLLL
LLLLLLLLLLLLLLL__L LLLLLLLLLLLL_LLLLLLL LL_ LL_ _
LLLLLL
LLLLLLLLLLLLLLLLL~ ~LLLLLLLL~~LLLLLLLL ~L ~LLLL ~L
LLLLLL~
LLLLLLLLLLLLLLLL _LLLLLLLLLL LL LLLLLLL___
LLLLLLLLLL
LLLLLLLLLLLLLLLL LL~LLLLLLLL~ LL LLLLLLLLLLLL
LLLLLLL~
LLLLLLLLLLLLLLLL_ __L _L LLLLLLLL LLL_
LLLLLLLLLLLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLL L~ LLLLLLLL
LLLLLLL~LLLLLLLLLLLLLLLL~
LLLLLLLLLLLLLLLLLLLL___L_ LL LLLLLLL LLLL LLLLLLLLLLLLLL
~~LLLLLLLLLLLLLLLLLLLLLLLL LLLLL~ LLLLL ~~~~~~~~~
LLLLLLLLLLLLLLLLLL_ _ LLL _LLLLL
~~~~~~LLLLLLLLLL~ LLLLLL
LLLLL _LLLLLL
LLLLL L L LLLLLLL
LLLLL__LL _L__LLLLLLLL
LLLLLLLLLL LLLLLLLLLLLL
LLLLLLLLLLLLLLLLLLLLLL
~LLLLLLLLLLLLLLLLL~~
LLLLLLLLLLLLL
~~~~~~~~~
magic-dd
Signaler
27/03/2008 à 21:45
Ce classeur t'auras donné du fil à retordre.
je t'envoi toute ma gratitude pour cette super aide dont tu m'as fais
part.
merci à toi tout est encore une fois parfait.
cordialement
loic
Ce classeur t'auras donné du fil à retordre.
je t'envoi toute ma gratitude pour cette super aide dont tu m'as fais
part.
merci à toi tout est encore une fois parfait.
cordialement
loic
Vous avez filtré cet utilisateur ! Consultez son message
Ce classeur t'auras donné du fil à retordre.
je t'envoi toute ma gratitude pour cette super aide dont tu m'as fais
part.
merci à toi tout est encore une fois parfait.
cordialement
loic
1
2
3