IF Function with 3 outcomes

[McCaughley7]

Hi

I have written the formula below into column C5 but its not quite right as when B5 is blank it still returns Pending...

=IF(B5>"","",IF(Q5="","Pending","Shipped"))

What I am trying to achieve is the following

IF B5 is blank then C5 will be blank
IF Q5 is populated then C5 will state Shipped
IF Q5 is not populated but B5 is then CS will state Pending

Thanks for looking

[The_Snook]

Hi McCaughley7,

Try:

=IF(B5="","",IF(Q5<>"","Shipped",IF(AND(B5<>"",Q5=""),"Pending","")))

Regards,

Snook

[McCaughley7]

Excellent - works perfect

Thanks

[The_Snook]

You're welcome, cheers for the rep points.