LOOKING FOR FORMULA FOR LETTER GRADING IN EXCEL

Ad

Hi again,

it would seem that you posted twice. Pls click here for you other post with my response.

Hope this be of initial help/idea. Pls post back how things turned up or should you need additional information.

Good luck and kind regards. Thank you for using FixYa.

Posted on Nov 02, 2008

Ad

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.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

Ad

EXCEL view the operation as a function fX and you enter it like this: =MINUS(H21,H22) This will show up in the cell and on the function bar above the column letters. The cell number would have a value in it. In this example H21 would have the value 10,and H22 would have the value 5. The formula would reside say in H23 and would show the result of the operation as 5.

10

5

5 (Formula in cell is as shown above)

10

5

5 (Formula in cell is as shown above)

Sep 19, 2017 | Excel Computers & Internet

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

Parts of the Excel 2007 Screen

Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

Deeply repair Excel file password and unlock Excel spreadsheet with use Microsoft Excel unlocker password software. You can simply use this software which completely crack Excel sheet password and excel users very easily read Excel worksheet without any trouble.More information-: http://www.msoffice.excelpasswordunlocker.com/

Aug 16, 2010 | Microsoft EXCEL 2004 for Mac

www.youtube.com/watch?v=xOU_hL2_zBo

i havent watched it, but i think it might help. hope it helps, enjoy

i havent watched it, but i think it might help. hope it helps, enjoy

Nov 16, 2008 | Microsoft EXCEL 2004 for Mac

Hi,

If you can email experts@fixya.com to forward me your email address (*should this be agreeable*), I can send you a copy of an excel sheet that automatically computes the grade and have the final grade in 1.0, 1.25, 1.50, 1.75 etc. You can then substitute the A, B, C.

Hope this be of initial help/idea. Pls post back how things turned up or should you need additional information.

Good luck and kind regards. Thank you for using FixYa.

If you can email experts@fixya.com to forward me your email address (

Hope this be of initial help/idea. Pls post back how things turned up or should you need additional information.

Good luck and kind regards. Thank you for using FixYa.

Nov 02, 2008 | Microsoft Windows XP Home Edition

I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

This link has some custom formulas for excel that you can download:

http://www.ozgrid.com/VBA/Functions.htm

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

This link has some custom formulas for excel that you can download:

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Computers & Internet

The most likely problem is that you (or somebody) has R1C1 reference style turned on.

In the TOOLS menu, choose OPTIONS and switch to the GENERAL tab. Look for the checkbox labeled R1C1 reference style. If it is checked, this will cause your symptoms.

Just uncheck the box and click OK.

I'm not sure what happens to existing formulas. If you (or somebody) has written formulas that rely on the R1C1 style, I don't know if they automatically get updated to the regular style or not, but that should be easy to discover.

In the TOOLS menu, choose OPTIONS and switch to the GENERAL tab. Look for the checkbox labeled R1C1 reference style. If it is checked, this will cause your symptoms.

Just uncheck the box and click OK.

I'm not sure what happens to existing formulas. If you (or somebody) has written formulas that rely on the R1C1 style, I don't know if they automatically get updated to the regular style or not, but that should be easy to discover.

Jan 10, 2008 | Microsoft Excel for PC

Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.

Wayne

- Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
- On the
**Format**menu, click**Cells**, and then click the**Protection**tab. - Select the
**Hidden**check box. - Click
**OK**. - On the
**Tools**menu, point to**Protection**, and then click**Protect Sheet**. - Make sure the
**Protect worksheet and contents of locked cells**check box is selected.

Wayne

Dec 28, 2007 | Computers & Internet

Get on Excel web sight and look at Excel Tutorial close to bottom of page. Follow the instructions.

Sep 17, 2007 | Microsoft Office Standard for PC

Mar 08, 2014 | Microsoft Windows XP Home Edition

62 people viewed this question

Usually answered in minutes!

×