Test ISBLANK on Excel Table Column

[DaveBlakeMAAT]

Hi

I am having a bit of a brain fart!

I have the following formula

=IF(MIN(AsBuiltWorkPaper[QTY])=0,"Error","OK")

AsBuiltWorkPaper[QTY] is a column in an Excel table, and I am trying to amend the above formula with an OR to also return "Error" if any cell in the column is blank.

I have tried doing it as a standalone formula but can not seem to get the correct result. I have tried both standard and array (ctrl+shift+enter)

Any ideas greatly received.

Regards

Dave

 

[Tetra201]

Maybe

=IF(OR(COUNTIF(AsBuiltWorkPaper[QTY],{0,""})),"Error","OK")

 

[DaveBlakeMAAT]

Thanks Tetra

That is perfect, your help is very much appreciated.

regards

Dave

 

[Tetra201]

Glad to have helped.