How do I check for cells that are empty in excel using IF function

Help Studio
, ,
1

I will be checking for one column, and in this column, there would be some cells that are empty. Using the IF condition, how do I do so?

2

Hi @Shannon_Quek ,

If you are using for each row activity, it can be checked by

string.isnullorempty(CurrentRow("ColumnName").toString) in the if activity condition.

image

Regards,

3

@Shannon_Quek ,

CurrentRow("ColumnName").ToString=""

image

Regards,

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.