Want product of values wit respect to +ive and -ive numbers

[wb35102]

Hi

I have +ive and -ive numbers in column G from cell G6 onward.

I have also two more columns H and I which has some values.

Now what i want,

i want product of values in G with H and I. if value in column G is +ive then it should be multiplied with respective column H value. and if value of column G is negative then it should be multiplied with the respective value of column I.

Sample file is attached for further explanation

[AliGW]

Try this:

=G6*IF(G6<0,I6,H6)

[wb35102]

Hi Thanks a lot it worked