Check if on of cell in specific columns is empty

[jaryszek]

Hi,

i need code or FORMULA to check if one cell in the table row is empty.

Screenshot_13.png

If one from 3 cells from columns: Header1, Header2, Headers 3 are empty - return TRUE
If all are fulfilled - return FALSE.

So in example we will get from Order 1:
FALSE,
FALSE,
TRUE
FALSE

Please help with finding best solution,
Jacek

[bakerman2]

If one from 3 cells from columns: Header1, Header2, Headers 3 are empty - return TRUE
If all are fulfilled - return FALSE.

After reading carefully I think answer would be:
TRUE,
TRUE,
FALSE
TRUE

Please Login or Register  to view this content.

[jaryszek]

thank you very much!!!

CountA is doing the job

Best,
Jacek

[bakerman2]

You're welcome and thanks for rep+.