Multiple IF/AND Statements Formula

HYG_Support

I have a row called "Clear To Ship" and "Build Date". I want to create another column with the following logic:

If Clear to Ship is Blank and Build Date is Blank, then put "No Where"

If Clear to Ship is Not Blank and Build Date is Blank, then put "Factory"

If Clear to Ship is Not Blank and Build Date is Not Blank, then put "TES"

If you could help that would be great.

Thank you.

David Ruff

Hi - I hope this is helpful:

=IF(AND(ISBLANK([Clear to Ship]@row), ISBLANK([Build Date]@row)), "No Where", IF(OR(ISBLANK([Clear to Ship]@row), ISBLANK([Build Date]@row)), "Factory", "TES"))

David Ruff

Hi - I hope this is helpful:

=IF(AND(ISBLANK([Clear to Ship]@row), ISBLANK([Build Date]@row)), "No Where", IF(OR(ISBLANK([Clear to Ship]@row), ISBLANK([Build Date]@row)), "Factory", "TES"))