editing formula.

[josaiah]

=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

 

[Marcelo Branco]

hi,

there is a confusion. so sorry abt tat.
i saw the formula you posted.

i've got it.
its working now. thanks alot! u're a great help.

No problem.

You are welcome and thanks for the feedback.

M.