I am trying to write a complexed formula (for me).
What I want to say is…..IF M3, N3 or O3, = “Home” and AE3=”Home” then times V3, W3, or X3 by P3, Q3 or R3 (if Home is in M3, then it is V3*P3*.98, If Home is in N3 then it is W3*Q3*.98, if Home is in O then it is X3*R3*.98)
IF M3, N3 or O3, = “Home” and AE3=”Draw” then I want to say -V3 (If Home is in M3), -W3 (If Home is in N3) or -X3 (If Home is in O3)
IF M3, N3 or O3, = “Home” and AE3=”Away” then I want to say -V3 (If Home is in M3), -W3 (If Home is in N3) or -X3 (If Home is in O3)
The formula which I have completely messed up now is currently…. =IF(AND(M3="home",AE3="home"),V3*P3*0.98,""),IF(AND(M3="home",AE3="draw"),V3*P3*0.98,-V3),IF(AND(M3="home",AE3="away"),V3*P3*0.98,-V3)
What I want to say is…..IF M3, N3 or O3, = “Home” and AE3=”Home” then times V3, W3, or X3 by P3, Q3 or R3 (if Home is in M3, then it is V3*P3*.98, If Home is in N3 then it is W3*Q3*.98, if Home is in O then it is X3*R3*.98)
IF M3, N3 or O3, = “Home” and AE3=”Draw” then I want to say -V3 (If Home is in M3), -W3 (If Home is in N3) or -X3 (If Home is in O3)
IF M3, N3 or O3, = “Home” and AE3=”Away” then I want to say -V3 (If Home is in M3), -W3 (If Home is in N3) or -X3 (If Home is in O3)
The formula which I have completely messed up now is currently…. =IF(AND(M3="home",AE3="home"),V3*P3*0.98,""),IF(AND(M3="home",AE3="draw"),V3*P3*0.98,-V3),IF(AND(M3="home",AE3="away"),V3*P3*0.98,-V3)