# 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"))

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.

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1