No Blank formula (oposit ISBLANK)

[Yacov]

Hi.

Is there a formula that i can use part of =IF / =IFS (the cell is not blank). As there is =IFS(ISBLANK(A1).
E.g. =CONCATENATE(IFS(ISBLANK(A1),"",(the cell is not blank(A1),"YES")

 

[Ron Coderre]

=IF(NOT(ISBLANK(A1)),
or
=IF(COUNTA(A1),

Does that help?

 

[JoeMo]

If A1 is empty (blank) this will return a zero-length string, otherwise it will return YES.

=IF(ISBLANK(A1),"","YES")

Is that what you want?

 

[Yacov]

Tried this one, didn't work!

 

[Rick Rothstein]

Tried this one, didn't work!

Tried which one (you have three formula offerings from two different people)?

Also, just saying "didn't work" tells us nothing useful... describe in what way it didn't work... Did you get an error message? If so, which one? What did you see happen and what did you expect to happen? Etc.

Also, here is another formula that you can try...

=IF(LEN(A1),"Yes","")

 

[Yacov]

The (NOT(ISBLANK(A1)) worked.

Thanks

 

[jtakw]

Double posted: https://www.mrexcel.com/forum/excel-questions/1066826-concatenate-part-if-blank.html#post5123580