Help with blanks

[Lorie1693]

Hi ... I'm, using this formula to assign a 1 if cell meets criteria, and zero if it does not
IF(CW200>=60%,1,0)

However, if the field is blank, it is bringing back a 1 which we want to be zero. Not sure how to resolve

 

[Fluff]

Hi & welcome to MrExcel.
How about

IF(and(cw200<>"",CW200>=60%),1,0)

 

[Lorie1693]

Hi & welcome to MrExcel.
How about

IF(and(cw200<>"",CW200>=60%),1,0)

perfect, ty

 

[Fluff]

You're welcome & thanks for the feedback.