HELP WITH formula

[josaiah]

hi, this is my current formula

=IF(B3<>"",ABS(IF(OR(F3="SGD",H3="SGD"),SUMIF(F3:H3,"SGD",G3:I3),IF(ISNUMBER(MATCH(F3,{"JPY"},0)),G3*K3/100,IF(K3<>"",G3/K3,0)))),"")


i would like to change the criteria

if F3 is "SGD" pick G3
if H3 is "SGD" pick I3

there will only be a SGD in either F3 or H3.

if no SGD in either of the cell, from F3, pick either "AUD","NZD","EUR","GBP","USD","CAD","CHF" and G3 * K3

if none of the Currency can be found, pick G3 and / by K3

and if it "JPY" in F3, pick G3 / K3 and /100.

 

[josaiah]

=IF(B4<>"",ABS(IF(OR(F4="SGD",H4="SGD"),SUMIF(F4:H4,"SGD",G4:I4),
IF(ISNUMBER(MATCH(F4,{"EUR","AUD","NZD","USD","CAD","CHF","GBP"},0)),G4*K4,IF(K4<>"",G4/K4,0)))),"")

HI, THIS is my current formula.

i want to add in if F4 = JPY, G4/K4/100

can i know where should i add this?