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!

Ad

No tmaking promises but try pushing F9 and for future make sure the Automatic caluculation is turned on.

Posted on Aug 04, 2009

Ad

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

Ad

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

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

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

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

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

- open ur spreadsheet from your files that you want to insert a dynamic date and time
- select the cell into which you want to insert the dynamic date and time.
- Type "=now()" (ignore quotation marks) into the selected cell.
- 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

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

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

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

Nov 30, 2008 | Microsoft Excel for PC

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!!!

Hope this will FixYa!!!

Sep 30, 2008 | Microsoft Excel for PC

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

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:

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

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Computers & Internet

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

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

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

Mar 25, 2008 | Microsoft Excel for PC

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

Mar 02, 2008 | Microsoft Windows XP Home Edition

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!

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

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

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.

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...

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.

Check for circular references.

×