If fields have text in - mark another field complete

[Nikki]

Hi,

I have a list of about 10 rows that I want text (from drop down boxes) to be
entered into. Once each cell within that list has something entered into it
I want the top row to say 'Complete'. Is there a formula to do this?

Thanks

Nikki

 

[jpdphd]

Hi,

I have a list of about 10 rows that I want text (from drop down boxes) to be
entered into. Once each cell within that list has something entered into it
I want the top row to say 'Complete'. Is there a formula to do this?

Thanks

Nikki

Nikki
One way is
=IF(COUNTBLANK(A2:A10)=0,"Complete","")
jpdphd

 

[CyberTaz]

Another variant:

=IF(COUNTA(G11:G20)<10,"","Complete")

You could also insert something between the "", such as Incomplete.

Regards |:>)
Bob Jones
[MVP] Office:Mac