ProductIf

Hi!

I need help.

In column "F", I have numbers.
In column "G", I have numbers.
In column "H", I have 3 options (words). -> Won, Lost, Cancel

In column "I" I want the following:

IF "H" = "Won" Then "I" = "F" * "G"
IF "H" = "Lost" Then "I" = "G" * (-1)
IF "H" = "Cancel" Then "I" = "G"

Example:

F1=2
G1=3
H1=Win
I1=F1*G1=2*3=6

F2=3
G2=4
H2=Lost
I2=4*(-1)= -4

F3=5
G3=8
H3=Cancel
I3=G3=8


So in column "I" I want:
- sum of "F" and "G"
- negative "G"
- equal G

Depending on what is in the "H" column. I am new and have no idea how to do this, I am hoping someone here could help me. I am still learning and sumif and sumifs functions are easy for me, and could do this for sums myself... but here I need a product.

I hope I wrote clear enough what I want, thanks for the help.

No this does not work pike... I have excel 2007 if it makes a difference.

Basicaly I don't care what the function is - be it IF function or whatever else, I just need something to check a column, and do 3 different things depending on what that column that it check says... So always checking for "Win" "Lost" "Cancel" and then doing one of the 3 predetermined actions for each (multiplying, making negative, or just copying cell value.

Check example.jpg hope it explains bit better then words.