Question about Computers & Internet
Any one of the subject mark is lessthen and equal to 35 no rank give to the student but total is only give.
and arrange the all students give conditions
Check all the Marks with IF Function if Mark is less than 35 give the total mark else give the rank
here m1,m2,m3 ...are the cells denoting Marks, Totalmark is the cell Showing total marks and Grade is the grade applied for the condition. here also you can use one more if function to find the grade among A,B,C,D,E
First this function check whether any of the given marks are less than 35. if any of the marks is less than 35 it will get the answer TRUE for the OR Function and you will get the Totalmark Cell VAlue, else it will go to Grade Clause.
Posted on Dec 08, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 05, 2016 | Microsoft Office Computers & Internet
Feb 02, 2011 | Microsoft Excel 2007 Home and Student...
May 19, 2010 | Microsoft Office Professional 2007 Full...
Jul 11, 2009 | Microsoft Office Professional 2007 Full...
Jan 23, 2009 | Microsoft Office Professional 2007 Full...
Dec 06, 2008 | Microsoft Computers & Internet
Aug 11, 2008 | Microsoft Excel for PC
Aug 07, 2008 | Microsoft Excel for PC
Sep 11, 2007 | Microsoft Office Standard for PC
7,824 people viewed this question
Usually answered in minutes!