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
Try to change the format of the cell to number etch....
Posted on Apr 23, 2009
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).
click here to download the app (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
19,085 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: