Check formula in excel

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
tootatoota
Posts: 56
Joined: Fri Apr 17, 2020 2:33 am

Hi,
Can someone please look at my formula because it is coming up error in Status and i cannot see why?
=IF(AND(AF8<105,J3>3,J3<5),IF(AK9>0,IF(OR(AG9<AI9*0.9,H4=0),"GREEN","LAY"),""))
AF8 is Market percentage J3 is mins before OFF AK9 is when i want to LAY and AG9<AI9 by 10% is when i want to green
I cant see where its wrong
All help very much appreciated
Thanks
User avatar
Trader724
Posts: 559
Joined: Fri Dec 27, 2019 11:22 pm

=IF(AND(AF8<105;J3>3;J3<5);IF(AK9>0;IF(OR(AG9<AI9*0,9;H4=0);"GREEN";"LAY")))
User avatar
tootatoota
Posts: 56
Joined: Fri Apr 17, 2020 2:33 am

Thankyou so much Trader
Regards Toota
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”