Hi,

Am Wed, 19 Jun 2013 13:13:33 +0100 schrieb Cherrygrocery:

My original formula: =IF(P6N6,"Not Met","Met")

I want to add: If cells P6 and N6 shows blank, show blank as well
(instead of Met or Not Met).

try:
=IF(LEN(P6&N6)=0,"",IF(P6N6,"Not Met","Met"))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2