I am trying to write a function, that
- if (G3 = W, then (H2+F3)
- if (G3 = L, then (H2-D3)
- If (G3 = P, then = 0 or do nothing)
I can get the function to work for just W or just L etc, but not all 3 together.
Currently I have:
=IF(ISNUMBER(SEARCH("W",G3)),H2+F3) which works for W and
=IF(ISNUMBER(SEARCH("L",G3)),H2-D3) which works for L and
=IF(ISNUMBER(SEARCH("P",G3)),"") which works for P but I was wondering how to put them all into 1 function.
Thanks
Bookmarks