Formula to determine if a velue exists or not

[danniaus]

Hello

So I have 3 fields

E26, E27, E28

What formula can I use to do the following:

Check to see if there is a value in any of the cells and if there is a value in one cell populate E25 with a "YES"

Thanks in advance

 

[Peter_SSs]

Does this work for you? It should give YES if one or more cells ha a value.

=IF(COUNTBLANK(E26:E28)=3,"NO","YES")

 

[danniaus]

Hi Peter, thanks for your response, unfortunately it isn't working. Can I ask what the significance of the 3 is?

 

[Rick Rothstein]

Hi Peter, thanks for your response, unfortunately it isn't working. Can I ask what the significance of the 3 is?​

In what way is Peter's formula not working? Are you getting an error message (if yes, what is it) or is it saying "YES" when the cells are blank (if so, do you have formulas in cells E26:E28)?

While you are at it, does this formula work...

=IF(LEN(E26&E27&E28),"YES","NO")

 

[Peter_SSs]

Can I ask what the significance of the 3 is?

There are 3 cells in your range E26, E27 and E28.
Rick has asked some pertinent questions about your response to my suggestion.
If you do have formulas in any of those cells, can you please post those formulas?