Results 1 to 4 of 4

Thread: excel formula

  1. #1
    rafiquey is offline Senior Member+
    Last Online
    7th March 2024 @ 10:15 AM
    Join Date
    13 Feb 2007
    Posts
    431
    Threads
    191
    Credits
    1,691
    Thanked
    15

    Default excel formula

    کچھ دنوں پہلے ایکسل کے بارے میں کسی صاحب نے پوسٹ کیا تھا کہ اگر چار عدد ڈاکٹرز ہوں، 3 انجنئیر ہوں، 2 کارپینٹر ہوں اور 3 ڈرائیورز ہوں تو اگر ہمیں صرف ڈاکٹرز کی تنخواہ معلوم کرنا ہو تو اس کا فارمولا کیا ہوگا۔ یہ فارمولا کسی صاحب نے پوسٹ کیا تھا لیکن مجھے مل نہیں رہا۔ اگر دوبارہ شئیر کردیں تو نوازش ہو گی۔
    شکریہ
    رفیق

  2. #2
    ramkhans's Avatar
    ramkhans is offline Senior Member+
    Last Online
    17th February 2023 @ 12:13 AM
    Join Date
    23 Oct 2009
    Location
    Hyderabad
    Gender
    Male
    Posts
    77
    Threads
    8
    Credits
    1,674
    Thanked
    3

    Default

    bro excel sheet bhejen jis p ap ko wo formula chahiye aur thori detail ap ko laga k deta hon, meri nazar se nahn guzri aisi koi post...

  3. #3
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    AAp sumif ka formula use kr sakty hian e.g.

    =SUMIF(B2:B7,"Doctor",C2:C7)
    faraz karain b2 sa b7 tak aap k designation/occupation hain. aur unki salary/wages CD sa C7 tak hian tu aap ya formula use kar lain. Aap Criteria change kar sakty hain aur spelling ka khyal rakhya ga.

    regards,

  4. #4
    rafiquey is offline Senior Member+
    Last Online
    7th March 2024 @ 10:15 AM
    Join Date
    13 Feb 2007
    Posts
    431
    Threads
    191
    Credits
    1,691
    Thanked
    15

    Default

    جزاکم الله خیراً

Similar Threads

  1. Help Me (Excel Formula)
    By sfahad13 in forum Ask an Expert
    Replies: 1
    Last Post: 2nd December 2017, 10:15 AM
  2. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  3. excel pr formula
    By meerabkhan in forum Ask an Expert
    Replies: 5
    Last Post: 30th March 2014, 03:30 PM
  4. Excel Formula Help
    By kasolangi in forum Ask an Expert
    Replies: 4
    Last Post: 8th January 2011, 12:23 AM
  5. Solved excel formula
    By alim khan in forum Solved Problems (IT)
    Replies: 6
    Last Post: 30th December 2010, 05:30 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
  •