Hi All,
I cant get my IF statement to work properley.
I want to fire a bet into the market upon meeting certain criteria but i want that to stop when the market goes inplay.
On my sheet inplay is G1.
So this is my existing working IF statement
=IF(E70="1","LAY ","")
need that to fire except when G1= In Play
Any Ideas ?
I been trying to do nested IF stsatements but cant seem to get it right.
Thanks
IF statement needed
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
or...
=IF(AND(E70=1,G1<>"Inplay"),"LAY","")
You can add as many items into that AND() as you like eg AND(A1=1 , B1=2 , Z1 <> 999 , etc,etc)
It's easier to read than nested IFs. You can use OR() as well
=IF(AND(E70=1,G1<>"Inplay"),"LAY","")
You can add as many items into that AND() as you like eg AND(A1=1 , B1=2 , Z1 <> 999 , etc,etc)
It's easier to read than nested IFs. You can use OR() as well