Question about Microsoft Excel for PC

5 Answers

EXCEL FORMULA NOT WORKING

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!

Posted by on

  • 4 more comments 
  • bdanner Dec 01, 2008

    Sum formulas are not recognizing new data in the range referenced in the sum formula.

  • Anonymous Jan 09, 2009

    I do a simple formula in a cell, eg =SUM(A1*2), and it calculates correctly, however, when I grab the corner of that cell to drag it down to copy the formula, it just copies the same text in the cells, but the formula displayed for that cell is correct, but it doesnt = what the formula says

  • Anonymous Apr 14, 2009

    I'm having the same problem, only in a specific instance of Excel on a specific computer.  The formula copies over correctly but does not display the correct answer.  The answer is the same as the location from which the formula was copied.  It is NOT just copying the value, however.  It is actually copying the formula.

  • vinny2cool Apr 15, 2009

    I have the exact same problem. Say A1 has value 1, A2 has formula =A1+1. Obviously, it evaluates to 2. When I click the corner and drag, all the formula are copied correctly (A2+1, A3+1, A4+1, etc), but all cells display '2', not 3,4,5... as they should. The cells only evaluate to the proper formulas if I explicitly select the them and press 'Enter'. This only happens on some computers, and not all the time, so it looks like a bug...

  • Anonymous Apr 17, 2009

    I have a similar problem. For me my data are just a simple sequence of numbers "1, 2, 3,..." (The cell values are just numbers, no formula at all). Used to work fine in the past when I drag the bottom right corner of the cell downwards, but suddenly it just starts to "copy and fill" rather than running in an incremental series. The problem lies in this particular worksheet only, if I add a new worksheet, the filling of series works fine in that new sheet.

  • Danilo Mante
    Danilo Mante May 11, 2010

    Check for circular references.

×

5 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Vice President:

    An expert whose answer got voted for 100 times.

    Governor:

    An expert whose answer got voted for 20 times.

    Corporal:

    An expert that has over 10 points.

  • Expert
  • 1 Answer

No tmaking promises but try pushing F9 and for future make sure the Automatic caluculation is turned on.
EXCEL FORMULA NOT WORKING - ace3905.gif

Posted on Aug 04, 2009

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 2 Answers

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

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Expert
  • 80 Answers

Please copy and paste the formula and show me the data in the cells that apply to the formula

Posted on Nov 28, 2008

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

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

EXCEL FORMULA NOT WORKING - 6a338f3.pnga9d1f59.png

Posted on Oct 16, 2010

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Try to change the format of the cell to number etch....

Posted on Apr 23, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

What is formula new excell


I certainly can't take the time to explain v lookup to you in this forum, but I can direct you to several sites that you can familiarize yourself with it. It's going to take you time to to understand it.

http://spreadsheets.about.com/b/2008/03/17/excel-vlookup-3.htm

http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm

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

Jun 21, 2009 | Microsoft Computers & Internet

2 Answers

I need a running balance in a column for a petty cash spreadsheet


In the first row of numbers, assume row 3 for example (leaving 2 rows for titles, put in cell E3: =C3+D3. In the next row (assuming row 4, put in cell E4: =C4+D4+E3. Use fill down to populate this formula all the way down.

Jun 18, 2009 | Microsoft Excel for PC

1 Answer

Excel Real-Time


  1. open ur spreadsheet from your files that you want to insert a dynamic date and time
  2. select the cell into which you want to insert the dynamic date and time.
  3. Type "=now()" (ignore quotation marks) into the selected cell.
  4. Press the "Enter" key on your keyboard to enter the formula into the selected cell. You will now see the current date and time appear in the cell you typed the formula into. (Date and time will update every time the "Enter" key is pressed )
.

Feb 17, 2009 | Microsoft Computers & Internet

2 Answers

How to do profit and loss a/c in ms excel


Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Description
Amount
Formula
Sales Product A
1,000.00

Sales Product B
1,000.00

Total Sales
2,000.00
SUM(C1:C2)
Cost of Sales Product A
500.00

Cost of Sales Product B
200.00

Total Cost of Sales
700.00
SUM(C5:C6)
Gross Profit
1,300.00
SUM(C4-C7)



Auto
25.00

Utilities
50.00

Payroll
300.00

Office Supplies
20.00

Total Expenses
395.00

Net Profit
905.00
SUM(C8-C14)


I hope this helps

Mark

Jan 05, 2009 | Microsoft Computers & Internet

1 Answer

Percentage formula


=(Click cell that you want to work out 30% of)*30/100

Nov 30, 2008 | Microsoft Excel for PC

1 Answer

Excel Spreadsheet


It could have a virus or simply too much data in it or too much data linked to it. Try doing a copy of the whole spreadsheet, and then paste the data into a new spreadsheet. If it doesn't contain too many different formulas, try pasting only the values, and then replace the formulas manually. You might also try just deleting the links, if there are any. If this doesn't solve it, reply to this thread and let us know.

Hope this will FixYa!!!

Sep 30, 2008 | Microsoft Excel for PC

1 Answer

BASIC EXCEL FORMULA


Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

columns: A B C D
rows
1 20 3
2 10 4
3 15 2
4 1 2 3


Then suppose you type in the following formulas (in the D column):

columns: A B C D
rows
1 20 3 =A1+B1
2 10 4 =A2-B2
3 15 2 =A3*B2
4 1 2 3 =sum(A4:C4)


Then the following answers will appear in the D column:

columns: A B C D
rows
1 20 3 23
2 10 4 6
3 15 2 30
4 1 2 3 6

Sep 29, 2008 | Microsoft Computers & Internet

1 Answer

Percentages in Excel


No problem, Melinda, I am here to help!

If I understood correctly, your spreadsheet looks something like this:
A B C D
1 Question Yes No Total
2 Is sky blue? 20 2 22
3 Is world round? etc.

In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
1) click on the cell where you have the division formula
2) clck on Format in the top menu bar
3) click on Cells
4) click on the Number tab (if you're not already there)
5) click on Percentage in the list of categories
6) click OK

To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

Good Luck!
Regards,
RichMTech

Aug 08, 2008 | Microsoft Excel for PC

2 Answers

Should I use countif or if or what ??


hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

1 Answer

Works suite 2006 spreadsheet


THERE MAY BE ERROR IN OFFICE INSTALLATION SO PLZ UNINSTALL YOUR OFFICE AND REINSTALL THE OFFICE

Mar 02, 2008 | Microsoft Windows XP Home Edition

Not finding what you are looking for?
Microsoft Excel for PC Logo

19,085 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...