# Thread: excel

1. ## excel

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. Senior Member+
Last Online
21st June 2018 @ 01:58 AM
Join Date
07 Feb 2009
Location
Lahore
Gender
Male
Posts
58
Threads
12
Credits
790
Thanked
6
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.

3. nyc

#### Posting Permissions

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