Question about Business & Productivity Software

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

×

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

3 Answers

Re: Excel 2011, how can I change permissions


Amazon.com: Excel for Mac 2011

amazon.com > ... > Business & Office > Spreadsheet

Amazon.com, Inc.Excel for Mac 2011 lets you create easy-to-analyze spreadsheets you can ... MicrosoftOffice Home and Student 2016 for Mac ' Mac Key Card ... Learn More; ASIN: B003YCOJBC; Item model number: D46-00803; Date first .... Imagine my surprise when the Excel installation disk would not load on my Mac Mini's DVD drive.

Amazon.com: Customer Reviews: Excel for Mac 2011

www.amazon.com/Microsoft-D46-00803-Excel...201...

Amazon.com, Inc.Find helpful customer reviews and review ratings for Excel for Mac 2011 at Amazon.com. ... Desktops & Monitors Computer Accessories & Peripherals Externaldrives, .... I, too, much preferred Windows version of MS-Office 2003 over Windows ....when the Excel installation disk would not load on my Mac Mini's DVD drive.

ms excel mac 2011 english dvd [d46-00803] - Computer ...

www.cworld.com.au > Software and Licensing > Retail Software
MS EXCEL MAC 2011 ENGLISH DVD [D46-00803]

Jan 05, 2016 | Microsoft Office Business & Productivity...

1 Answer

Is it possible to modify a cell content without deleting everything in ms excel?


Hi There.
Yes - it is possible to modify the content of a cell without deleting everything.
Place your curser in the cell without writing or doing anything.
You will now be able to se the content of the cell in the upper row - same place where you give in formular etc.. Here you can edit the content of the cell - a part of the text or formular without loosing everything.

Regardscarlon90.jpg

Feb 02, 2011 | Microsoft Excel 2007 Home and Student...

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

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

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

1 Answer

Related MS Excess 2003


Hi Esd,

I'm assuming you meant 'Excel' since 'SUM' is the command you're looking for.

If your totaling Column D for rows 5 through 35, this is what you would need in the cell your total would be:

=SUM(D5:D35)

Also, when in doubt, Click on the '=' (equal sign) in the formula bar for a list of functions and help using them.

Any problems? Click the Askme button near my name.

Thanks for using Fixya.
Mike

Dec 06, 2008 | Microsoft Business & Productivity Software

1 Answer

EXCEL


When you say prepare . .
What data is going in - and what needs to come out ?

At the moment - it looks like you just need standard coloumn control...
From the standard input columns do you need to break the data down into specifics (Ie time frames etc...which will incorporate cumulatives..)
I would personally suggest using MS Access - you will have greater control and GUI to minimize accidental deletion etc..

Aug 11, 2008 | Microsoft Excel for PC

1 Answer

I have data in excel


Excel cannot search by colour, however you can rank by adding a column, in which you place a ranking value (if you colour code as well you can appear to rank by colour), sorting by the ranking column will give you the same ranked rows together in numerical order.

Sep 11, 2007 | Microsoft Office Standard for PC

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?
Business & Productivity Software Logo

Related Topics:

7,823 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...