Question about Microsoft Excel for PC
I HAD A SIMPLE ADDITION FORMULA IN A CELL THAT WAS WORKING THE LAST TIME I WAS IN MY SPREADSHEET AND NOW WHEN I TRY TO CHANGE THE FORMULA WITHIN THAT SME CELL, IT KEEPS ADDING UP TO "0" NO MATTER WHAT NUMBERS OR FORMULA I PUT IN IT. HELP!
No tmaking promises but try pushing F9 and for future make sure the Automatic caluculation is turned on.
Posted on Aug 04, 2009
It sounds like you're trying to copy formulas that are changing as you copy them. All formulas with cell reference will change as you copy them unless you put dollar signs in front of the cell references. For example =SUM(A1*2) will change to =SUM(B1*2) when copied one column to the right and change to =SUM(A2*2) if copied down to one row. If you want the cell to always refer to A1 then the formula should read =SUM($A$1*2).
Posted on Jan 10, 2009
Please copy and paste the formula and show me the data in the cells that apply to the formula
Posted on Nov 28, 2008
You're probably in "Formula Auditing" mode.
Select [Tools'Formula Auditing'Formula Auditing Mode on] menu. You can use the <Ctrl>+" shortcut to switch from on mode to the other
Posted on Oct 16, 2010
In this case, try some solution like:
1. Enter number without any formatting; avoid adding any decimal separator or currency
2. Secondly also make sure numbers are not formatted as text values, check some points like
? Numbers formatted as the text is by default gets left -aligned while formal numbers are right aligned in cells.
? The number format box on the home tab in the number group displays the Text
? When many cells with text numbers are selected on the sheet, the Status Bar only shows Count; while usually, it shows average, count, and sum of numbers.
? There may be green triangle shape in the top left corner of the cell or leading apostrophe visible in the formula bar.
For More Tips Visit this:
9 Top Fixes Solutions For Excel Formulas Not Working Error MS Excel Repair...
Posted on May 11, 2017
Try to change the format of the cell to number etch....
Posted on Apr 23, 2009
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.
Posted on Jan 02, 2017
Tips for a great answer:
Jun 21, 2009 | Microsoft Computers & Internet
Jun 18, 2009 | Microsoft Excel for PC
Feb 17, 2009 | Microsoft Computers & Internet
Jan 05, 2009 | Microsoft Computers & Internet
Sep 30, 2008 | Microsoft Excel for PC
Sep 29, 2008 | Microsoft Computers & Internet
Aug 08, 2008 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
19,118 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: