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