# Problems with IF statement where more than 1 argument is needed

1. ## Problems with IF statement where more than 1 argument is needed

My intention is to create a formula that states if cell value (AZ2) is 0 then return "Not Applicable", If the Cell value is between 1 and 96 then return "Training" and if the cell value exceeds 96 then return "Trained".
This is the formula I have been working on but wont be accepted. Where am I going wrong?

=IF((AZ2>=96, "Trained"), IF(AND(AZ2>96, AZ2<0), "Training", "Not Applicable"))  Register To Reply

2. ## Re: Problems with IF statement where more than 1 argument is needed

Your middle bit there is saying if AZ2 is both greater than 96 AND less than zero, which cannot be the case.

As you have tested for AZ2 being greater than or equal to 96 in your first IF, then if the second IF is evaluated it must be because AZ2 is less than 96, so you don't need to test for that. Try it this way:

=IF(AZ2>=96, "Trained", IF(AZ2>0, "Training", "Not Applicable"))

Hope this helps.

Pete

EDIT: you also had some brackets in the wrong place.  Register To Reply

3. ## Re: Problems with IF statement where more than 1 argument is needed

Thanks, Ill give it a go. Been a while since I used Excel and the grey matter is a bit rusty.   Register To Reply