MikeGreen1972
New Member
- Joined
- Jan 28, 2015
- Messages
- 19
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
=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
