How to find out no value cell?

[ryan_mayu]

Hi all,

Ther is a column in my data which contains a lot of empty cells. Now I want to add another column to set group for this column. 

I tried if formula, switch formula and isblank formula. It always shows errors. Could you please let me know how to solve this problem?

Thanks a lot.

[MFelix · Accepted solution]

Hi @ryan_mayu,

Belive that in the first two formulas you are getting error because your column is a number format and you compared it to a string "". On the ISBLANK formula you have the parentisis on the incorrect position redo your formula to:

Column = IF(ISBLANK(Table1[Column1]) ; BLANK() ;1 )

Regards,

MFelix

[ryan_mayu]

@MFelix， Thanks for you help. Ifblank formula works now.