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.
Bookmarks