3 IFs argument in one formula

[Cherrygrocery]

Hi all,

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

My original formula: =IF(P6>N6,"Not Met","Met")

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

Please help guys :

 

[Claus Busch]

Hi,

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

My original formula: =IF(P6>N6,"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(P6>N6,"Not Met","Met"))


Regards
Claus Busch

 

[Calicojack]

Hi all,

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

My original formula: =IF(P6>N6,"Not Met","Met")

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

Please help guys

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