mercredi 20 avril 2016

IF condition from excel to VBA

I'm confused on how to pass this problem from excel to VBA:

In excel:

Theoric:

=IF(cond1, IF(cond2, statement1,statement2),IF(cond2,statement3,statement4))

Actual excel cells:

=IF($B$2="USD",IF($B$170="USD",B173,B173/B$1),IF($B$170="USD",B173*B$1,B173))

In VBA:

If cond1 Then
If cond2 Then
Statement1
Else
Statement2
End if
Elseif cond2 Then
statement3
Else
statement4
End if

Would it be ok ?

Aucun commentaire:

Enregistrer un commentaire