Webhosting in Pakistan
Results 1 to 4 of 4

Thread: excel

  1. #1
    king_Raja's Avatar
    king_Raja is offline Senior Member+
    Last Online
    31st March 2014 @ 08:51 AM
    Join Date
    23 Jun 2010
    Location
    Hyderabad
    Age
    26
    Gender
    Male
    Posts
    400
    Threads
    89
    Credits
    0
    Thanked
    5

    Default excel

    Webhosting in Pakistan
    friend moje ye pata karna Tha ke excel ka formula ha jo (If) ha mane ek marksheet bana ni ha mane ye karna ha
    name marks grade parcntage

    1 name 90 A-1 vgood
    2 name 80 A good
    3name 70 B




    ab moje koi ye bataye ke me ye kase karo ke me 90 se 100 tak koi bi marks liko to false na aye A-1 leka aye or agy vgood lika aye keya is le bary me kise ko pata ha ager pata ha tu bato plz

  2. #2
    IT.BOY's Avatar
    IT.BOY is offline Senior Member
    Last Online
    17th November 2017 @ 11:13 AM
    Join Date
    26 Dec 2007
    Location
    *MAA KI AGOOSH*
    Gender
    Male
    Posts
    28,374
    Threads
    651
    Credits
    764
    Thanked
    3079

    Default

    [FONT="Jameel Noori Nastaleeq"][CENTER][COLOR="Blue"][SIZE="5"][B]Coming Soon...:)[/B][/SIZE][/COLOR][/CENTER][/FONT]

  3. #3
    denzees is offline Senior Member+
    Last Online
    21st June 2018 @ 01:58 AM
    Join Date
    07 Feb 2009
    Location
    Lahore
    Gender
    Male
    Posts
    58
    Threads
    12
    Credits
    550
    Thanked
    6

    Default

    Asalam-o-Alaekum!

    Jis cell main aap ne "Obtained Marks" likhe howe hain, us se next cell main yeh wala farmula lagana hey. Farz karain k app k Marks B5 main likhe hain to aap C5 main yeh farmula lagain ge. Jehan par "A+" , "A" ya "B" likha hey, wehan par app commas main rehte howe kuch b likh sakte hain. Is formula ko sare cells main drag kar dain.

    =IF(B5>90,"A+",(IF(B5>=90,"A",(IF(B5>=80,"B",(IF(B 5>=70,"C",(IF(B5>=60,"D","FAIL")))))))))


    60 se kam marks wale students Fail ho gain ge. Aap is ko b tabdil kar sakte hain.
    share your results please.
    Regards.

  4. #4
    winxp's Avatar
    winxp is offline Senior Member+
    Last Online
    10th December 2018 @ 07:59 PM
    Join Date
    16 Apr 2010
    Location
    Peshawar- KPK
    Gender
    Male
    Posts
    126
    Threads
    28
    Credits
    6
    Thanked
    7

    Default

    Webhosting in Pakistan
    nyc

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. MS EXCEL - Al-Quran in Excel
    By Mubashir Aziz in forum General Discussion
    Replies: 45
    Last Post: 16th March 2015, 08:59 PM
  3. Not Working Zaara's Excel Tutorial In Pdf & 300 Excel Tips
    By iftikhar01 in forum General Discussion
    Replies: 94
    Last Post: 14th May 2012, 04:28 PM
  4. Need Help in excel
    By nsm1870 in forum Solved Problems (IT)
    Replies: 4
    Last Post: 16th March 2010, 11:02 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
  •