multiple IF functions, expert excel users please help

[martyloo]

how do I have multiple if functions all in one cell?

i.e:- =if(and(this cell equals this and this cell equals this display = "","")
=if(and(this cell equals this and this cell equals this display = "","")
=if(and(this cell equals this and this cell equals this display = "","")
=if(and(this cell equals this and this cell equals this display = "","")

Is this possible, if so how many can I have in one cell? I am creating a BlackJack Strategy spreadsheet which for example:

When Ten and two is pressed for your cards
and Ten is pressed for the dealers card the function would be

=if(and(C1=10,B1=2,C3=10),"HIT","")

Obviously I need to repeat this function hundreds of times for different card Hand Combinations against the Dealer, is there anyway of doing this?

 

[Ruddles]

You can nest IF statements up to seven deep but if you want my advice, the very fact that you're asking this question suggests that you're going to have problems writing formulae as complex as that. Trouble-shooting them if they don't work properly is going to present you with a nightmare as you won't be able to see what the individual parts are evaluating to.

I suggest you use a couple of 'helper' columns to calculate the point holdings in each hand, then a third column to calculate whether to hit or not.