Help in excel

[ITDWARRIOR]

dear friends main yahan ek excel file attach ker raha hon is main mainy likh diya hai k mujhe kis kisim ka formula chahiye.

kindly help.

[golden43]

=IF(A3="OK","3",IF(A2="Direct FMR","2",IF(A3="Extra Use FMR","2",IF(A3="Faulty FMR","2",IF(A3="Neutral FMR","2",IF(A3="Ok FMR","2",IF(A3="Direct","1",IF(A3="Extra Use","1"))))))))

yeh Formula Apply Karo.. maih ney Ap ke file maih Yeh formula Apply kya But maih File Ab upload nhe kar paraha..

[ITDWARRIOR]

thanks for reply but mera problem is se solve nahin ho raha. kiyun k FMR k more than 1000 remarks hain or her remark main FMR starting main ya MID main ya End main araha hai tu main kitni condition lagaonga..
yahan tu mainey thori si file share ki hai bhai mere pass tu buhat bari file hai jis main different kisim k remarks hain jis main FMR ka word use kiya gaya hai.

[shail khan7]

wt

[imranjhang]

=IF(A2="Ok",3,IF(NOT(ISERROR(FIND("FMR",A2))),2,1))

[syar]

Salam,
Aap imran ka deya hoa formula use karain. Ya drust kam kare ga. Agar aap k word case sensative nahee hain, yane capital or small dono use krte hain tu find ki jagha search ka function use karain. Q k find case sesative ha. Yane jo word dainge wohe find kare ga wrna error dega.

Regards

[ITDWARRIOR]

thanks all of you dear friends.
mera kam ho gaya is formula se.

Thanks syar bhai "Find" ki jaga "Search" use kerny se mera kam perfect ho gaya.

Jazakallah.

[imranjhang]

thanks syar bhai for increasing my knowledge too... mujhay nahi pata tha k Find case sensitive hai...