Hi Sukumar, I am not sure whether this is what you are looking for.. Have a look in the attached file whether it suits your requirement.
--- *Sixthsense **:) Man of Extreme & Innovative Thoughts :)* On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA <vijayajith...@gmail.com>wrote: > Hi, > > Students English maths sceience Grades > suresha 45 80 90 90-100 A > srinivas 25 36 60 80-90 b > sunyana 38 65 70 60-80 c > sunitha 80 90 68 36-60 d > vinay 40 28 60 0-35 fail > Need to slove using multiple ifs (please give some more examples like this) > > pls see the attached file > > > > Thanks in advance > > > sukumar > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Solution File - Student Mark.xls
Description: MS-Excel spreadsheet