Question about Microsoft Excel for PC

# Excel Formula I have been using excel for a number of years and make good use of the formulae. However, today when I enter a simple formula e.g. =F112+G112, I am not getting any result. The formula as written above appears in the cell and not the actual answer to the formula. Any ideas what might be happening?

Posted by on

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that hasĀ over 10 points.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

Make sure that the cell is formatted as a number, not as text. (Right-click the cell, format cell, number, choose NUMBER.)

Posted on Dec 21, 2007

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What is formula to find percentage of females in my workplace?

To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

### How to do percentages in Excel - Office Blogs

https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
Feedback

### How to Calculate Percentages in Excel

www.excelfunctions.net > Excel-Formulas
Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

### Excel formula: Get percentage of total ' Exceljet

https://exceljet.net/formula/get-percentage-of-total
Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Computers & Internet

### What are the formulas in grading the grades uisng microsoft excel

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.

1. All formulas begin with an equals sign (=).
2. 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.
3. 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.
4. 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.
5. 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

### Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...

Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

### Formula for excel to calculate years of giving.

In AJ3 thru BT3 put a number. Doesn't matter what number. Then type the following formula into a cell and instead of pressing enter press and hold control, then press and hold shift, and then press enter, and then release all the keys.

=COUNT(IF(NOT(ISBLANK(AJ2:BT2)),AJ3:BT3)

Jun 03, 2009 | Haier Chest Freezer HNCM070E

### Rounding Time in Excel 2007

format the cells that contains times and net time worked as time format you using Enter the simple formula   =if(c14<=0,Int(0),(c14-c13))

Feb 04, 2009 | Microsoft Excel for PC

### Excel

Step1. Start Microsoft Excel and open the file you want to change. Step2. Double-click on the cell where you want the total to appear. Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell. Step4. Enter the formula, then press Enter. Follow the steps below for an example. Step5. Enter an opening parenthesis character: (. Step6. Enter a cell name. For example: =(E2. Step7. Press the + key. Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3). Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4. Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell. \$('.Article .Steps .Image').each(function(i,e){ e = \$(e); e.find('img').error(function(){ \$(this).unbind(); e.remove(); }); });
Tips & Warnings
• Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
• Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")
I hope it helps!!!

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

### Excel formulas

type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.

Sep 13, 2008 | Microsoft Computers & Internet

### Excel Formula

Yes you can and there are two choices. The simple solution is to label a cell "divide by" and put your number in that filed. Then, by changing only that, your answer (in a separate cell) will be available.
There are more complex solutions -assuming your divide by number had some rhyme and reason that could be put in place but.....try this first and at a later date go back and play. Learning to do that will give you more than a fair amount of Excel expertise....something you may find fairly valuable as you continue on using Excel. FYI...I have developed full blown applications on Excel....it is an excellent tool. Hope this helps....Tango.

Feb 05, 2008 | Microsoft Excel for PC

#### Related Topics:

160 people viewed this question

Level 3 Expert

Level 3 Expert