# #UNPARSABLE / #INCORRECT ARGUMENT

Having trouble trying to make this formula work. Perhaps it needs re writing using different syntax.

I understand that perhaps i am using too many arguments for the IF command.

I am looking to achieve the below.

• If `Column1` is not blank and `Column2` is not blank, return "Answer 1".
• If `Column1` is not blank and `Column2` is blank, return "Answer 2".
• If `Column1` is blank and `Column2` is not blank, return "Answer 3".
• If `Column1` is blank and `Column2` is blank, return "Answer 4".

=IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), NOT(ISBLANK([STOCK CUSTOMER]@row))), "In Stock - Allocated", IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), ISBLANK([STOCK CUSTOMER]@row)), "In Stock - Unallocated", IF(AND(ISBLANK([CHASISS NO.]@row, NOT(ISBLANK([STOCK CUSTOMER]@row))), "On Order - Allocated", IF(AND(ISBLANK([CHASISS NO.]@row), ISBLANK([STOCK CUSTOMER]@row)), "On Order - Unallocated", "No Match")))))

• ✭✭✭✭✭✭

Hi Tom, Try this: =IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), NOT(ISBLANK([STOCK CUSTOMER]@row))), "In Stock - Allocated", IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), ISBLANK([STOCK CUSTOMER]@row)), "In Stock - Unallocated", IF(AND(ISBLANK([CHASISS NO.]@row), NOT(ISBLANK([STOCK CUSTOMER]@row))), "On Order - Allocated", IF(AND(ISBLANK([CHASISS NO.]@row), ISBLANK([STOCK CUSTOMER]@row)), "On Order - Unallocated", "No Match"))))

• ✭✭✭✭✭

Hi @Tom Stock! Have you tried using the AI Tool "Generate Formulas"? It's my go to when I'm stuck and has been a life saver. You should be able to copy and paste the description of what you are trying to achieve in the formula description.

Michelle Cullen

• ✭✭✭✭✭✭

Hi Tom, Try this: =IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), NOT(ISBLANK([STOCK CUSTOMER]@row))), "In Stock - Allocated", IF(AND(NOT(ISBLANK([CHASISS NO.]@row)), ISBLANK([STOCK CUSTOMER]@row)), "In Stock - Unallocated", IF(AND(ISBLANK([CHASISS NO.]@row), NOT(ISBLANK([STOCK CUSTOMER]@row))), "On Order - Allocated", IF(AND(ISBLANK([CHASISS NO.]@row), ISBLANK([STOCK CUSTOMER]@row)), "On Order - Unallocated", "No Match"))))

• Hi Michelle,

Thanks for the reply. I tried AI a couple of times but still didn't help.

Thanks for this. This sorted my issue!

Assuming i was just missing some information?

• ✭✭✭✭✭✭