ISNOTBLANK

[instereo911 via OfficeKB.com]

I don't know what I can use for ISNOTBLANK"

I have a report that has validation lists on both A and B and want C to
generate a "P" (for purchase) if B has information in it


I need to c1 to say the following =IF(A1="John Doe",IF(B2="ISNOTBLANK","P","")




A B
C
john doe Cell Phone (from validation menu) P
jersy jim Stickers (from validation menu)
harry happy

Any ideas?

Thanks everyone.

 

[Jay Freedman]

Turn the idea around. Instead of asking whether the cell is _not_ blank, ask
whether it _is_ blank, and reverse the 'true' and 'false' clauses of the IF
field:

IF (B2="") "", "P"

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

<>"" should do the trick.