Results 1 to 7 of 7

Thread: EXcel Formula Prob.. Solve Please

  1. #1
    Refan's Avatar
    Refan is offline Advance Member
    Last Online
    2nd March 2024 @ 03:35 PM
    Join Date
    14 Jul 2008
    Location
    Karachi - Pakis
    Age
    34
    Posts
    2,300
    Threads
    564
    Credits
    3,045
    Thanked
    147

    Red face EXcel Formula Prob.. Solve Please

    اسلام علیکم جناب اپ سب کو میری طرف سے
    میں ایکسل میں فارمولا لگا رہا ہوں تو وہ درجہ زیل وینڈو شو کرتا ہے اس کی کیا وجوہات ہیں کیا کوئی میری مدد کرسکتا ہے
    واسلام
    میں انتظار کرونگا آپ سب کے جوابات کا ضرور دیجئے مھربانی

    Attached Images Attached Images  

  2. #2
    poootna is offline Junior Member
    Last Online
    21st May 2009 @ 03:29 PM
    Join Date
    21 May 2009
    Posts
    2
    Threads
    0
    Credits
    0
    Thanked
    0

    Default

    You have a mistake in the last IF condition; "IF>59" should be "IF(H3>59" Replace it and the formula should work fine.

  3. #3
    Refan's Avatar
    Refan is offline Advance Member
    Last Online
    2nd March 2024 @ 03:35 PM
    Join Date
    14 Jul 2008
    Location
    Karachi - Pakis
    Age
    34
    Posts
    2,300
    Threads
    564
    Credits
    3,045
    Thanked
    147

    Default

    i should that..
    PHir bi Yahi prob.. ari hay ............. Koe hay or............. Excel Expert Help me Plase...

  4. #4
    diptra's Avatar
    diptra is offline Senior Member+
    Last Online
    1st August 2009 @ 11:09 PM
    Join Date
    30 Apr 2009
    Location
    Peshawar
    Posts
    32
    Threads
    4
    Credits
    997
    Thanked
    0

    Default

    janab agar aap ko result H3 k cell mein chahiey to wahan formula lagao, aur condition mein jis cell k reference aay ga woh G3 ho ga, na k H3...

    aap formula mein H3 ko G3 sey replace karein inshahAllah masla solve ho jay ga aur IF>59" should be "IF(H3>59" is ko be theek kar lein

    Allah Hafiz

  5. #5
    shah2010 is offline Member
    Last Online
    1st April 2010 @ 08:47 PM
    Join Date
    18 Jan 2009
    Location
    Gwadar Balochistan
    Age
    34
    Posts
    1,219
    Threads
    297
    Thanked
    9

    Default

    kia app bata saktay hain k ya formoola kis chez ka he.
    matlab zarab,+,-,.% ya kise ore ka

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

    Doost aap ka percentage column G3 main hay nah kah H3 main. If condition to kafi purani ho chuki hay aap lookup ko istaa'mal kar kay daikhain ....

    =LOOKUP(G3,{0,60,70,80,90},{"Fail","D","C","B","A" })

    Iss key ilawa aap nay yah condition to lagai he naheen agar woh kissi subject main fail ho jata leekan percentage 70% hay to aap nay ussay B Grade day dia ........

    neechay dia gia formula check karay ga kah B3 : D3 tuk tamam subject main 60 ya iss say ziyada number hain aur phir grade day ga bayshuk percentage 80% ho .......
    =IF(COUNTIF(B3 : D3,">59")=3,LOOKUP(G3,{0,60,70,80,90},{"Fail","D", "C","B","A"}),"Fail")
    Last edited by Mubashir Aziz; 25th May 2009 at 02:57 PM.

  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

    Main nay General Discussion main ek file upload key hay aur Excel main Student Marks Sheet banany kay liye best file hay ........


    http://itdunya.com/showthread.php?p=719936#post719936

Similar Threads

  1. 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
  2. Excel Formula Help
    By adnanmomin in forum Ask an Expert
    Replies: 4
    Last Post: 31st May 2013, 06:38 PM
  3. Excel Formula Help
    By umerali10 in forum Ask an Expert
    Replies: 12
    Last Post: 19th November 2012, 02:32 PM
  4. plz help me Excel formula
    By zahid4942 in forum Ask an Expert
    Replies: 3
    Last Post: 16th July 2012, 08:54 PM
  5. help a Excel formula
    By Ameen Asim in forum Ask an Expert
    Replies: 0
    Last Post: 6th May 2012, 04:08 PM

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
  •