Le compte est bon
Est-il possible de faire calculer le compte est bon avec excel ?
On entre 7 nombres et excel doit utiliser les 6 premiers nombres une seule fois pour trouver le 7ème en utilisant (+ - / x).
J'ai déjà essayé mais je n'arrive pas à faire passer les + - / x pour des variables ...
s
La partie plutôt complexe sera déterminer quelles opérations faire, mais pour surmonter le problème des variables, c'est assez simple.
On affecte chaque opérateur à une constante, qu'on interprète, petit exemple (avec un unique calcul)
Private Const Addition = 1
Private Const Soustraction = 2
Private Const Multiplication = 3
Private Const Division = 4
Sub Cherche()
'opération exemple (10 + 42 x 21 -12 / 36 + 71)
MsgBox Test(10, Addition, 42, Multiplication, 21, Soustraction, 12, Division, 36, Addition, 71)
End Sub
Function Test(V1 As Long, Op1 As Byte, V2 As Long, Op2 As Byte, V3 As Long, _
op3, V4 As Long, Op4 As Byte, V5 As Long, Op5 As Byte, V6 As Long) As Long
Select Case Op1
Case Is = 1:
Test = V1 + V2
Case Is = 2:
Test = V1 - V2
Case Is = 3:
Test = V1 * V2
Case Is = 4:
Test = V1 / V2
End Select
Select Case Op2
Case Is = 1:
Test = Test + V3
Case Is = 2:
Test = Test - V3
Case Is = 3:
Test = Test * V3
Case Is = 4:
Test = Test / V3
End Select
Select Case op3
Case Is = 1:
Test = Test + V4
Case Is = 2:
Test = Test - V4
Case Is = 3:
Test = Test * V4
Case Is = 4:
Test = Test / V4
End Select
Select Case Op4
Case Is = 1:
Test = Test + V5
Case Is = 2:
Test = Test - V5
Case Is = 3:
Test = Test * V5
Case Is = 4:
Test = Test / V5
End Select
Select Case Op5
Case Is = 1:
V1 = Test + V6
Case Is = 2:
V1 = Test - V6
Case Is = 3:
V1 = Test * V6
Case Is = 4:
V1 = Test / V6
End Select
End Function