Formulas - Test if Cell is Populated

[koolkat]

I want to do an Iif statement but test if a cell is populate at all. Anyone
know how to do this?
so Iif([Text1]="Anything", YES, NO) What do I put for ANYTHING

 

[JulieS]

Hi Koolkat,

Try:

IIf(Len([Text1])> 0, "yes", "No")

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Andrew Lavinsky]

IIF([Text1]="",No,Yes)


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[koolkat]

oh my god, duh! thanks!

IIF([Text1]="",No,Yes)


- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

I want to do an Iif statement but test if a cell is populate at all.
Anyone
know how to do this?
so Iif([Text1]="Anything", YES, NO) What do I put for ANYTHING

.