IF statement needed

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
leerudd
Posts: 28
Joined: Tue Dec 01, 2020 1:29 am

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
User avatar
Euler
Posts: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

Nest the IF's, I can't remember what the inplay cell returns and I'm not near my PC at the moment, but...

=IF(E70=1,IF(G1="Inplay","LAY",""),"")
leerudd
Posts: 28
Joined: Tue Dec 01, 2020 1:29 am

Thanks for the swift response but isnt that wrong ?
I apologise if im wrong but doesnt that say if in play, then Lay ?
User avatar
Euler
Posts: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

Euler wrote:
Tue Apr 27, 2021 9:22 pm
Nest the IF's, I can't remember what the inplay cell returns and I'm not near my PC at the moment, but...

=IF(E70=1,IF(G1="Inplay","LAY",""),"")
Sorry, I misread

=IF(E70=1,IF(G1<>"Inplay","LAY",""),"")
leerudd
Posts: 28
Joined: Tue Dec 01, 2020 1:29 am

Brilliant need to check it works now, Thanks
User avatar
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
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”