changing the "status" depending on criteria based in other cells

[baggers719]

Hi,

I'm trying to automatically change the status of a project which is dependent on the contents of other cells.

This is the criteria I need:

Column A displays either a "1" or "0" depending if certain criteria are met. This works ok.

I then want Column B to display the following:

Needs to display "Shipped" if column A = 1 and column AJ = "Shipped"
then if this is not true and only column A = 1 then it needs to say "Ready". Else the display should read "Not ready"

this is the formula I have used and I can't get it to work.

= IF(AND(A5=1,AJ="Shipped"),"Shipped", IF(AND(A5=1,AJ="Not Shipped"),"Ready","Not Ready"))

Thanks for your time. I really appreciate it as always.

Sean

 

[Joe4]

It looks like you forgot the row number after the "AJ" column references in your formula, i.e.

= IF(AND(A5=1,AJ5="Shipped"),"Shipped", IF(AND(A5=1,AJ5="Not Shipped"),"Ready","Not Ready"))

 

[Jared_8878]

=IF(AND(A1=1,AJ1="Shipped"),"Shipped",IF(AND(A1=1,AJ1<>"Shipped"),"Ready","Not Ready"))

 

[baggers719]

yes.. just noticed it. thanks