Linking cells to produce a specific message

[mandyo6]

Hi, I need to link 3 cells for a project regarding exercise. One cell has to use drop down to state "D","W","M" (daily, monthly, weekly), Another cell has the total of how many days you exercise a week and another has to say that if you exercise more than 4 times in a month your health is Poor<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
=if(AND(E2="D",H8>=5,"Excellent"),if(AND(E2="W",H8>=2,"Good"),if(AND(E2="M",I8<=4,"Poor")))). This is the statement I have written because this is how I understand it and Excel says it is wrong! Can anyone help please, it is difficult to explain what I am trying to do so I hope someone will understand it more by writing my incorrect statement. The paper also suggests that I might be able to do this by lookup?<o></o>
Thank you.<o></o>
<o> </o>

 

[Beezkneez]

Your error is about where the brackets lie. The criteria being assessed should be bracketed for the AND argument, with the outcome falling outside of the AND argument's brackets.
=IF(AND(E2="D",H8>=5),"Excellent",IF(AND(E2="W",H8>=2),"Good",IF(AND(E2="M",I8<=4),"Poor")))

 

[Michael M]

Hi and Welcome to the board
try

=IF(AND(E2="D",H8>=5),"Excellent",IF(AND(E2="W",H8>=2),"Good",IF(AND(E2="M",I8<=4),"Poor")))

 

[mandyo6]

Thank you so much for your reply it is very much appreciated, this has been driving me mad!

Kind regards,

Mandy