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.

 

[Fluff]

You need to move the bracket from after ,"in stock", to before the comma

 

[KillerOfGiants]

...AND(W3>0,X3=0,"IN STOCK")...

Your AND function has 3 items that must be true, but "IN STOCK" just seems to be by itself. Should it be Q3="IN STOCK"

 

[jimrward]

Retracted I was too slow

 

[Sheripres]

You need to move the bracket from after ,"in stock", to before the comma

I spent three hours trying to figure this out! You saved my life! Thank you so very much!

 

[Sheripres]

I spent three hours trying to figure this out! You saved my life! Thank you so very much!

Ugh...Still having one issue. It at least grabs AA3 as an answer, but I had a "true" statement on one of the Ands and it is still bypassing it. Getting there though!

 

[Fluff]

With AND both must return TRUE, maybe you need to use OR instead.

 

[Sheripres]

Retracted I was too slow

you can jump in with any ideas! The one I thought worked, didn't. Well, it worked for the AA3 result, but because I had a true statement on one of the "and" sections, it didn't recognize it.

Thank you!

 

[Sheripres]

With AND both must return TRUE, maybe you need to use OR instead.

I understand what you are saying, but where do I put the OR? When I use my mouse to see the logic and what I did, it seems correct, but it seems like it must be a comma or something with the parenthesis. Attaching pic to help explain. This is just my example so I can forward the formula to the end user.

Thank you!

 

[Fluff]

You still have the bracket in the wrong place.