members. umed ha sub thek thak hun ge. plz ye problem solve kar den. excel se matlaq ha. ms word ki file mai question ha jo xcel mai solve karna ha. plz jaldi reply karn thnx.
members. umed ha sub thek thak hun ge. plz ye problem solve kar den. excel se matlaq ha. ms word ki file mai question ha jo xcel mai solve karna ha. plz jaldi reply karn thnx.
bhai koi to maded kar de. kya kesi ko bhi excel nahn ata. lol
bhai ap ke file open nahe ho rahe hai aap ais ko dubra upload karo
jald he aap ke problem solve ho jaye ge.........
bhai file open ho rahe ha ap again check karn. thnx
Here is the solution of your query .....
For option A.
For Option B.Code:=IF(AND(B3>=15,C3>=50),1,IF(AND(B3>=10,C3>=70),2,IF(AND(D3>=12,F3>=45),3,IF(AND(D3>=20,F3>=40),4,"Out"))))
Code:=IF(OR(AND(B19>=15,C19>=50),AND(D19>=12,F19>=45)),"A",IF(OR(AND(B19>=10,C19>=70),AND(D19>=20,F19>=40)),"B","OUT"))
Hi,
thanks for appreciation........ Bus yaar thora buhat kaam chala laita houn and this is 101% my approach ..... have you seen my two threads ????
http://itdunya.com/showthread.php?t=82565
http://itdunya.com/showthread.php?t=87020
I'll wait for your comments
Bhai Raqim aap key hosla Afzai aur dua'oon ka buhat buhat shukaria ...... Agar aap ko koi bhi excel related problem ho to mujh say question poochin main pori koshish karoon ga solution kay liye ....
Duaoon main yaad rakhiye ga .......
very nice
brother mujay IF condition ka formate bhool gaya howa tha app ke maded say wo b revise ho gaya very thanx
External Site Link Not Allowed In Signature(ALi.HaiDEr)
Brother you can ask any query about excel or word any time but please mention in title Excel: <problem > So will definitely check
mubahir bhe ap k shukria mai chk kar k ap ko btata hun. thnx any way.
Bookmarks