How to change formula from excel to function.

[kttan]

totally 0 on VBA, hope can get full advice and explanation.

im having a very long formula, unable to learn macro to put it in, and i'm dono about vba coding.


below is my formula, and im need press shift ctrl and enter.
=IF(OR(EXACT(F2,"resistor"),EXACT(F2,"capacitor")),IF(INDEX(A_S!$H$2:$H$17,MATCH(1,(A_S!$D$2:$D$17=$F2)*(A_S!$E$2:$E$17<=$C2)*(A_S!$F$2:$F$17>$C2)*(A_S!$G$2:$G$17>=$D2),0))=3,D2+3,(INDEX(A_S!$H$2:$H$17,MATCH(1,(A_S!$D$2:$D$17=$F2)*(A_S!$E$2:$E$17<=$C2)*(A_S!$F$2:$F$17>$C2)*(A_S!$G$2:$G$17>=$D2),0)))),"")

[aarona]

how about:

Please Login or Register  to view this content.

[kttan]

how about:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

it not work,

other then this,im try do something like if A1 = "FORMULA1" then do formula 1 , if A1 = "FORMULA2" then do formula 2.