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 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).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

Amazon.com: Excel for Mac 2011

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 Computers & Internet

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.

Regards

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

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

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

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 Computers & Internet

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

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

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

Related Topics:

7,830 people viewed this question

Level 3 Expert

Level 3 Expert