Prev: Why is a scheduled 10 hour day overlap into the next day?
Next: customise timeline - add in day 0 (e.g. day -2,-1,0,1,2,3 etc)
From: koolkat on 11 May 2010 12:39
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
From: JulieS on 11 May 2010 12:51
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

On 5/11/2010 12:39 PM, koolkat wrote:
> 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
From: Andrew Lavinsky on 11 May 2010 12:57
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


From: koolkat on 11 May 2010 14:32
oh my god, duh! thanks!

"Andrew Lavinsky" wrote:

> 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
>
>
> .
>
 | 
Pages: 1
Prev: Why is a scheduled 10 hour day overlap into the next day?
Next: customise timeline - add in day 0 (e.g. day -2,-1,0,1,2,3 etc)