Student marksheet prepare wtih Ms Excel With following conditions

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

Posted by on

• nigandy May 11, 2010

is this the solution you want in MS Excel Please let me know so I will give you the solution

×

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

Check all the Marks with IF Function if Mark is less than 35 give the total mark else give the rank
for Ex:;
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

• rtnmani May 11, 2011

It is better in MSACCESS that I have dealt. If you want a demo, email me at rtn.mani@gmail.com

×

Hi,
a 6ya Technician 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 repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

How can microsoft word help student to excel in their particular fields

Hi,
Microsoft Word is a part of Microsoft Office Software of inter-related desktop office applications. Word, Excel and Power Point are main and widely used applications, which I think equally beneficial for students as well as executives. In short, MS Word provides facilities like typing a letter, report, thesis etc. Excel is for calculation and Power Point is for presentations. I believe that MS Office is a very powerful and extremely beneficial software. So, I recommend that every student should learn using Office Suite and enjoy its benefits.

Let me know if any further clarification/ assistance is required.

Hope it helps! Good Luck! Thanks for using Fixya!
CreativeTECH

Sep 06, 2011 | Microsoft Windows XP Professional

Hi..
Micosoft office contains many softwares like MS word, Outlook,Excel,Powerpoint etc
Now, MS Office is a PAID software, you need to pay for the whole software to use it.
However you can use openoffice software which is FREE alternative to MS office suite. Openoffice has it's own word, excel ,powerpoint files and it FREE TO USE.

Good Luck :-)
I have provided you a free of charge solution to your problem, please rate me accordingly.

May 19, 2010 | Microsoft Office Professional 2007 Full...

I got a new laptop but it dosnt have microsoft excel. arnt all laptop saposse to have it

No MS Excel is a part of the MS Office suite and comes seperately from some computers. Some brand new computers may come with a trial of the office suite, but not all computers come with office on it.

Dec 30, 2009 | Dell Inspiron 1525 Laptop

RANK FOR PASSING STUDENTS

You will have to use a logic saying If subject1 > 34 and subject2 >34 and subject3 > 34. Idead is to tell the prog that all subjects have to be > 34 by using the AND function. If you use OR function, then the first subject having > 34 will complete the condition and you will get the result, which will be wrong. So, use the AND function. How? Use the help on Using functions in Excel or whatever you are using. They all have it inbuilt.

Aug 22, 2009 | Computers & Internet

Where can i get the key for all the microsoft? like excel and word? is it the same key for all?

if you buy a license for the office suite, it will only ask for the product key one time and it will unlock word, outlook, excel, powerpoint, and access. if you purchase the professional version, this will include publisher and any other office suite software.

Jul 11, 2009 | Microsoft Office Professional 2007 Full...

Excel stops responding during the saving process

There may be following one or more reasons:-

1. MS office 2007 is currupt
2. System has a virus
3. Windows OS is currupt. (Make sure you are running MS Windows Xp SP2)

Here is the solution:-
1. Scan system with a good legal antivirus
2. Repair OS using utilities win Doctor or from win Xp installation disk (upgrade)
3. Repair MS Office 2007 by going Office Button --> Options --> Resources --> run Microsoft Diagnostics

Zulfikar Ali

Jan 23, 2009 | Microsoft Office Professional 2007 Full...

Not equal to

using MS EXCEL: start the operand with the following: IF _<>_value is true, value is false example: Not equal to A1<>B1, IF A1 not equal to B1

Sep 02, 2007 | Microsoft Office Standard for PC

Open Questions:

Related Topics:

7,841 people viewed this question

Level 3 Expert

Level 3 Expert

Level 3 Expert