Having issues with a conditional IF statement...

[MikeGreen1972]

I'm having a heck of a time with an IF statement. If the value of AK2 is "Y" I want AS2 to display "APPROVED". If the value of AK2 is "N" I want it to display "DISAPPROVED". If the value of AK2 is blank, I want it to display "PENDING".... BUT only if there is data in V2.

=IF(AK2="y","APPROVED",IF(AK2="n","DISAPPROVED",IF(V2>=0,"PENDING"))) will get me part of the way there, but I can't figure out how to make it display nothing if there is no data in v2.

Anything I try from this point on (i.e. V2<=0,"") or (v2="","") ends with a too many arguments error.... Help please!

Thanks,
Mike

 

[AlanY]

try this

=if(isblank(v2),"",IF(AK2="y","APPROVED",IF(AK2="n","DISAPPROVED",IF(V2>=0,"PENDING"))))

 

[dms37]

assuming v2 is always numeric and greater than or equal to zero as your formula implies, you need to add ,"" after "PENDING" in the final IF - basically what will it display if V2 is not greater than or equal to zero.

 

[bschwartz]

Try this variation:

=IF(AK2="y","APPROVED",IF(AK2="n","DISAPPROVED",IF(AND(V2<>"",AK2=""),"PENDING","")))

 

[Fishboy]

=IF(AK2="y","APPROVED",IF(AK2="n","DISAPPROVED",IF(AND(AK="",V2<>""),"PENDING","")))

 

[123rickfear]

=IF(V2="","no data",IF(AK2="y","APPROVED",IF(AK2="n","DISAPPROVED",IF(AK2="","PENDING")))) try this. I wasn't sure what you want the result to be if V2 is blank.

 

[dreid1011]

This will work as well.

=IF(AK2={"Y","N"},{"APPROVED","DISAPPROVED"},IF(AND(AK2="",V2<>""),"PENDING",""))

 

[bschwartz]

Another possibility:

=CHOOSE(IF(V2="",1,IF(AK2="",2,LOOKUP(AK2,{"N",3;"Y",4}))),"","PENDING","DISAPPROVED","APPROVED")

 

[abmati]

=if(v2="","",if(upper(ak2)="Y","approved",if(upper(ak2)="N","disapproved",if(ak2="","pending"))))

 

[MikeGreen1972]

Thanks guys! awesome solutions, different perspectives. I went with this one =if(isblank(v2),"",IF(AK2="y","APPROVED",IF(AK2="n","DISAPPROVED",IF(V2>=0,"PENDING")))) and it works like a charm. Thanks again!!