Help with a IF Formula

[jclaborn]

Hey Guys,

Appreciate all the support with excel!

Need help with this formula, and maybe iv laid it out incorrectly..

=IF(Y4="Complete"&AE4="1","Shipped",IF(Y4="Complete"&AE4="0","Ready not Shipped",IF(Y4="Ordered"&DD4="Complete","In-Process",IF(Y4="Ordered"&DD4="0","Not Started",""))))

[Pete_UK]

The & symbol is used for joining two text strings together, so your formula does not make any sense. I think you want to do something like this:

=IF(AND(Y4="Complete",AE4="1"),"Shipped",IF(AND(Y4="Complete",AE4="0"),"Ready not Shipped",IF(AND(Y4="Ordered",DD4="Complete"),"In-Process",IF(AND(Y4="Ordered",DD4="0"),"Not Started",""))))

You should also come up with a better thread title than the one you have now.

Hope this helps.

Pete

[Sam Capricci]

try it this way...
=IF(AND(Y4="Complete",AE4="1"),"Shipped",IF(AND(Y4="Complete",AE4="0"),"Ready not Shipped",IF(AND(Y4="Ordered",DD4="Complete"),"In-Process",IF(AND(Y4="Ordered",DD4="0"),"Not Started",""))))
[not tested]
Now, if your values in quotes are actually numbers and not text then drop the quotes around the numbers such as AE4=1 instead of AE4="1".
you can test what they are by putting =ISNUMBER(AE4) in a cell and if it returns false then it is text, if it returns true then it is a number and the quotes should be dropped.

[jclaborn]

Thanks guys, worked perfectly.. I had numbers in certain cells, dropped the quotes and it worked perfectly.. Not familar with IF's.. Learning them as I go.. IF(AND allows multiple logical expressions.. Got it. Thanks again.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

In future, please make your thread titles more detailed, telling us what you are trying to achieve with the formula. Thanks.

[Sam Capricci]

Glad we could help. And thank you for the rep!
And, thread titles are always important, please keep that in mind too.