=IF(B3<>"",ABS(IF(OR(G3="SGD",J3="SGD"),SUMIF(G3:J3,"SGD",H3:K3),IF(ISNUMBER(MATCH(G3,{"EUR","AUD","NZD","USD","CAD","CHF","GBP"},0)),H3*N3,IF(G3="JPY",H3/N3/100,H3/N3)))))
hi all, pls help to edit my formula.
if my cell N3 is blank, the value return #DIV/0!
i want it to return as 0
hi all, pls help to edit my formula.
if my cell N3 is blank, the value return #DIV/0!
i want it to return as 0