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
Bookmarks