back and lay in same formula,

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
conrad666
Posts: 18
Joined: Wed Sep 03, 2014 9:00 pm

Hello try to get it, but nope;/

In L row you put want to bet, back or lay.. And all kinde of formulas..
I have tried to select from a row say K70:74 In this
cells i have 3 items that another formulas handels for you
and can show you "BACK" -"LAY"- "NO"
HOW do i put the IF formula in L ROW becuse it can be 3 things that can be true.

-cell-
k70 NO
k71 NO
k72 NO
k73 LAY
k74 NO

conny
User avatar
conrad666
Posts: 18
Joined: Wed Sep 03, 2014 9:00 pm

I think i figured out:))
exampel
=OM('THE CLINT'!H7="BACK";"BACK";OM('THE CLINT'!I10="LAY";"LAY";"NO"))

conny
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”