nested if statements with and issue

[Sheripres]

Hello:
I can't seem to make this formula work. It is pretty straightforward, but maybe I have too many conditions? It works for the first two IF statements, but it then reads FALSE even though I have a TRUE statement on either of the two "AND" sections.

=IF(Q3="IC5/OTHER","NON-INVENTORY",IF(Q3="Inncom DIRECT","Inncom DIRECT",IF(AND(W3>0,X3=0,"IN STOCK"),IF(AND(W3>0,X3<0),"PARTIAL IN STOCK"),AA3)))

I hope I posted this correctly.

Thank you for any help.

 

[Sheripres]

You still have the bracket in the wrong place.

Sorry; I did move them, but it still didn't pick up the IN STOCK. I think I am asking this formula to do too much. ha I can separate it out in two columns and link it to the main column if I have to.

 

[Fluff]

You still have the bracket in the wrong place, it should be

=IF(Q3="IC5/OTHER","NON-INVENTORY",IF(Q3="Inncom  DIRECT","Inncom DIRECT",IF(AND(W3>0,X3=0),"IN   STOCK",IF(AND(W3>0,X3<0),"PARTIAL IN STOCK",AA3))))

 

[Sheripres]

You still have the bracket in the wrong place.

I am going to frame this formula! ha ha THANK YOU SO VERY VERY MUCH! I need to study what I did not understand. You are the best! I will close this as solved.

Again; thank you!!!

 

[Fluff]

Does the formula in post#12 work?

Also what version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Sheripres]

I don't know if my computer is acting crazy today in the office, but I was responding to previous threads and it was not updating on my end. Yes, I am on 365 now. I will update my profile. I am totally set and I did mark it as solved. Hope that reply came through. Thank you again!

 

[Fluff]

Thanks for updating your profile.
And glad we could help.