Currency Conversion Formula

[ASP]

Hi, I am new in excel formula and I needed help from the experts.

I was asked to convert the currency in the column G,H,I,J,K into MYR in column L. The purpose is easier to compare the pricing.
However, I was unable to do it with [=IF(G<>"",$G$2, IF(H<>"",$H$2, IF(I<>"",$I$2, IF(J<>"",$J$2, IF(K<>"",$K$2)))))]
Or, is there any other way to do it? Thank you.

 

[6StringJazzer]

Enter in L4 and copy down. This assumes that there is only one value in each row.

=SUMPRODUCT($G4:$K4,$G$2:$K$2)

 

[ASP]

Enter in L4 and copy down. This assumes that there is only one value in each row.

=SUMPRODUCT($G4:$K4,$G$2:$K$2)

Hi Jeff,

Thanks a lot.

 

[6StringJazzer]

You're welcome! I think there is a button or link in my post above so you can mark it as the solution.