Results 1 to 4 of 4

Thread: Help - Excel Expert

  1. #1
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default Help - Excel Expert

    Tamam IT dunya ke membarano ko mera Salam-

    Dear Excel Expert,

    A-Block B-Block C-Block TOTAL
    40% 10% 90% ? (Kitne %)= Want a formula


    Agar kisi ne A-Block mai 40% (100% mai se), B-Block mai 10% (100% mai se) or C-Block mai 90% (100% mai se) kam kiya hai to kul jama kitne % kam hua.

    Please solved my problem.


    Sukriya

  2. #2
    Lesson4me's Avatar
    Lesson4me is offline Senior Member+
    Last Online
    29th January 2019 @ 11:12 AM
    Join Date
    16 Jul 2008
    Posts
    342
    Threads
    32
    Credits
    1,160
    Thanked
    30

    Default

    Salamm::
    Aapka total kam ha = 300
    Work done by blocka+b+c = 140%
    total wok % =140/300=46%
    adjust column references & ranges.
    regards

  3. #3
    Lesson4me's Avatar
    Lesson4me is offline Senior Member+
    Last Online
    29th January 2019 @ 11:12 AM
    Join Date
    16 Jul 2008
    Posts
    342
    Threads
    32
    Credits
    1,160
    Thanked
    30

    Default

    or

    D2=average(a2:c2)

    will give you the same result

  4. #4
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default

    Thanks

Similar Threads

  1. Ask Excel Expert
    By Nadeem Ahmed Kh in forum Ask an Expert
    Replies: 9
    Last Post: 11th June 2014, 06:43 PM
  2. Koi ms excel expert hay?
    By sanafaiz in forum Ask an Expert
    Replies: 1
    Last Post: 20th February 2014, 04:18 PM
  3. excel expert
    By sabir sami in forum Ask an Expert
    Replies: 2
    Last Post: 2nd March 2013, 09:56 AM
  4. Solved MS Excel expert plz help
    By Sajid286 in forum Solved Problems (IT)
    Replies: 9
    Last Post: 21st July 2012, 10:03 PM
  5. MS EXCEL Expert plz help me
    By DJ_UMAR in forum Ask an Expert
    Replies: 2
    Last Post: 2nd September 2011, 12:06 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
  •