Page 1 of 2 12 LastLast
Results 1 to 12 of 16

Thread: "Challnge" kya ap ye kar saken ge?

  1. #1
    Join Date
    21 Dec 2008
    Location
    Karachi
    Gender
    Male
    Posts
    1,478
    Threads
    127
    Credits
    1,716
    Thanked
    94

    Default "Challnge" kya ap ye kar saken ge?

    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.
    Attached Files Attached Files

  2. #2
    Join Date
    21 Dec 2008
    Location
    Karachi
    Gender
    Male
    Posts
    1,478
    Threads
    127
    Credits
    1,716
    Thanked
    94

    Default

    bhai koi to maded kar de. kya kesi ko bhi excel nahn ata. lol

  3. #3
    ZoOp is offline Member
    Last Online
    14th October 2009 @ 01:12 PM
    Join Date
    03 Oct 2008
    Location
    City In Heaven
    Posts
    4,964
    Threads
    160
    Thanked
    17

    Default

    bhai ap ke file open nahe ho rahe hai aap ais ko dubra upload karo

    jald he aap ke problem solve ho jaye ge.........

  4. #4
    Join Date
    21 Dec 2008
    Location
    Karachi
    Gender
    Male
    Posts
    1,478
    Threads
    127
    Credits
    1,716
    Thanked
    94

    Default

    bhai file open ho rahe ha ap again check karn. thnx

  5. #5
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default Solution ..............

    Here is the solution of your query .....

    For option A.

    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"))))
    For Option B.

    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"))
    Attached Files Attached Files

  6. #6
    Join Date
    10 Jun 2009
    Age
    39
    Posts
    432
    Threads
    10
    Credits
    1,259
    Thanked
    25

    Default

    Quote mubsahir aziz said: View Post
    Here is the solution of your query .....

    For option A.

    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"))))
    For Option B.

    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"))
    I really appreciate your effort Brother if you have done this by urself then I can comment that your programming logic is strong !

  7. #7
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    Quote AtifRaza said: View Post
    I really appreciate your effort Brother if you have done this by urself then I can comment that your programming logic is strong !
    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

  8. #8
    راقم is offline Senior Member+
    Last Online
    11th July 2020 @ 06:23 AM
    Join Date
    16 Dec 2007
    Location
    کشمیر، جنت نظیر
    Age
    65
    Gender
    Male
    Posts
    400
    Threads
    86
    Credits
    -1
    Thanked
    83

    Default

    Quote mubsahir aziz said: View Post
    Here is the solution of your query .....

    For option A.

    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"))))
    For Option B.

    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"))
    بھائی مبشر عزیز،
    السّلامُ علیکم۔
    بہت خوب کام کیا۔۔ اللہ آپ کے علم میں برکت عطا فرمائے۔
    مجھے خود اس طرح کے فارمولے کی بڑی ضرورت تھی۔
    آپ کا بہت شکریہ، آپ نے میرا مسئلہ بھی حل کر دیا۔
    "راقم"

  9. #9
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Smile Thanks for your encouragement

    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 .......

  10. #10
    MindHunter's Avatar
    MindHunter is offline Advance Member
    Last Online
    2nd February 2021 @ 02:52 PM
    Join Date
    09 Jun 2007
    Gender
    Male
    Posts
    767
    Threads
    78
    Credits
    200
    Thanked
    39

    Default

    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)

  11. #11
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    Brother you can ask any query about excel or word any time but please mention in title Excel: <problem > So will definitely check

  12. #12
    Join Date
    21 Dec 2008
    Location
    Karachi
    Gender
    Male
    Posts
    1,478
    Threads
    127
    Credits
    1,716
    Thanked
    94

    Default

    mubahir bhe ap k shukria mai chk kar k ap ko btata hun. thnx any way.

Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 10
    Last Post: 31st October 2017, 11:15 PM
  2. """""Nokia ki themes ab ap khud bnain"""""
    By Adeel SR in forum Softwares
    Replies: 72
    Last Post: 4th July 2017, 03:16 PM
  3. Replies: 7
    Last Post: 26th October 2016, 09:35 AM
  4. """"""ہمسفر""""""
    By sheri in forum Urdu Adab & Shayeri
    Replies: 3
    Last Post: 26th October 2016, 09:10 AM
  5. Apni Marzi ka "FONT", "Colour", "Size" ko hamesha k leye select kerna seekhain.
    By Kutkutariyaan in forum New Members Training Center
    Replies: 498
    Last Post: 31st October 2015, 07:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •