Question about Computers & Internet

1 Answer

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
    nigandy May 11, 2010

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

×

1 Answer

  • 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
  • 9 Answers

Check all the Marks with IF Function if Mark is less than 35 give the total mark else give the rank
for Ex:;
if(Or(m1<35,m2<3,m3<35,.....),TotalMark,Grade)) [enter]
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

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Need help to recover with my accounting and math subject as I am very week in these subject.


hi, go to your library and see if they have any books there which may help you. "hsc essentials business studies" by clive a lincoln & michael lembach oxford university press, melbourne, 1994 pp48-57 could be helpful.
if you are able to find past past examination questions you should try to answer these using information in your text books and other reference books.
i was once in a similar situation, having missed very many classes and having done no reading at all in a particular subject for the dip a.i.i. i got hold of the past five years examination questions for the course. the weekend before the final examination i assumed that i was the person preparing the examination paper for the current year's examination. then looking at the course syllabus and the questions asked in the previous five years i prepared questions for the current year. i then studied and tried to answer these questions that i had prepared during the entire weekend. luckily the questions i had created and learned to answer covered the areas that were questioned in that final examination. i gained a high distinction in that paper.

Jan 21, 2015 | Computers & Internet

1 Answer

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

1 Answer

I just downloaded ms home and student 2007 for free but it seems i still need a product key


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.

http://download.openoffice.org/

Please click on the above link to download openoffice.


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...

3 Answers

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

1 Answer

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

3 Answers

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...

1 Answer

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

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

7,833 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...