excel formula if selection

[conrad666]

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. to put a back or lay bet or no

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

conny

[neeeel]

not clear what you are asking, but if you are wanting an if formula that gives you three options then you would do

=if(x, "BACK",if(y,"LAY","NO"))

So if x was true, you would get BACK, if x wasnt true, but y was true, you would get "LAY", if neither x or y were true, you would get "NO"

for x and y you would just replace with some logical expression

[conrad666]

Thanks should do it