Forum Discussion

Saud's avatar
Saud
Brass Contributor
Apr 22, 2023
Solved

A function indicating that the cells are filled

Hi All     I want a function stating that a certain number of cells are filled, and there may be numbers and texts here, so that if all the cells are filled, the phrase "Complete" appears, and if ...
excel
  • OliverScheurich's avatar
    OliverScheurich
    Apr 22, 2023

    Saud 

    =IF(FREQUENCY(LEN(A1:A5),0)>0,"not complete","complete")

    You can try this formula.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Apr 22, 2023

Saud 

=IF(FREQUENCY(LEN(A1:A5),0)>0,"not complete","complete")

You can try this formula.

 

  • Saud's avatar
    Saud
    Brass Contributor
    Apr 22, 2023

    OliverScheurich 

    Thank you very much

Resources