excel

[king_Raja]

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

[IT.BOY]

yahan dekhey....

[denzees]

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.

[winxp]

nyc