Complex If Condition

[jiguvaidya]

Dear friends, kindly give me the solution to fulfill following condition.

Worksheet Example : This is for one employee record

A B C D
1 Subject Need Status Trg Impart
2 ISO ISO/QMS (Here i 9103 (our rec.no.)
want cond.)
3 IT Tools Advance P903
4 Process Trg. 0 0
5 Behav. Soft Skill 0

Now i want the condition like : 1) if column D is having rec.no than display "Completed", (2) Column D is starting with "P" or is having "S" then display "Planned", (3) Column D is having 0 or Column B & D having 0 than display "NA".
In above Column B & Column D is calling by Index function from another sheet.
plz solved this.

[JBeaucaire]

Please Login or Register  to view this content.

Crossposting between forums requires that you provide a link to the other site.
http://www.mrexcel.com/forum/showthread.php?t=373615

I suggested this formula on that site. Did you even try it?
=IF(AND(ISNUMBER(D2),D2>0),"Completed",IF(OR(ISNUMBER(FIND("P",D2)),ISNUMBER(FIND("S",D2))),"Planned",IF(OR(D2=0,B2=0),"NA")))