Hi all,

Please help. I'm trying to come up with 3 IFs argument in one formula.

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).

Please help guys :(

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

Here is a simple way, add:
If(and(P6="",n6="")," ", if(p6n6,"Not Met","Met"))
Hope this helps!!!!
-Dave