Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
simple formlas not working
This should be really simple but we have a comptuer with excel that the
formuals will not work correctly. We are simply trying to subract column B from column A. It is set up in column C as =A1-B1 which gives me the correct answer but then if I copy it for rows 2 and on I always get the same answer as row 1. If you look at the formulas it is changing them to =A2-B2, =A3-C3 and so on but the answer is always the same. Also if I go and change the numbers in A1 or B1 to change the answer is C1 it will not change. Whatever the first answer is it will stay that number. Any help would be great. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
simple formlas not working
Hi, I think your calculation are in Manual, try to press F9 to calculate it.
You can change calc to automatic going to TOOLS | OPTIONS | CALCULATION | AUTOMATIC Hope it helps, regards from Brazil Marcelo "szelinko" escreveu: This should be really simple but we have a comptuer with excel that the formuals will not work correctly. We are simply trying to subract column B from column A. It is set up in column C as =A1-B1 which gives me the correct answer but then if I copy it for rows 2 and on I always get the same answer as row 1. If you look at the formulas it is changing them to =A2-B2, =A3-C3 and so on but the answer is always the same. Also if I go and change the numbers in A1 or B1 to change the answer is C1 it will not change. Whatever the first answer is it will stay that number. Any help would be great. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
simple formlas not working
That was the problem thanks so much for your help!
"Marcelo" wrote: Hi, I think your calculation are in Manual, try to press F9 to calculate it. You can change calc to automatic going to TOOLS | OPTIONS | CALCULATION | AUTOMATIC Hope it helps, regards from Brazil Marcelo "szelinko" escreveu: This should be really simple but we have a comptuer with excel that the formuals will not work correctly. We are simply trying to subract column B from column A. It is set up in column C as =A1-B1 which gives me the correct answer but then if I copy it for rows 2 and on I always get the same answer as row 1. If you look at the formulas it is changing them to =A2-B2, =A3-C3 and so on but the answer is always the same. Also if I go and change the numbers in A1 or B1 to change the answer is C1 it will not change. Whatever the first answer is it will stay that number. Any help would be great. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
simple formlas not working
thanks for the feedback
regards "szelinko" escreveu: That was the problem thanks so much for your help! "Marcelo" wrote: Hi, I think your calculation are in Manual, try to press F9 to calculate it. You can change calc to automatic going to TOOLS | OPTIONS | CALCULATION | AUTOMATIC Hope it helps, regards from Brazil Marcelo "szelinko" escreveu: This should be really simple but we have a comptuer with excel that the formuals will not work correctly. We are simply trying to subract column B from column A. It is set up in column C as =A1-B1 which gives me the correct answer but then if I copy it for rows 2 and on I always get the same answer as row 1. If you look at the formulas it is changing them to =A2-B2, =A3-C3 and so on but the answer is always the same. Also if I go and change the numbers in A1 or B1 to change the answer is C1 it will not change. Whatever the first answer is it will stay that number. Any help would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
click & drag not working | Excel Discussion (Misc queries) | |||
Help with what should be a simple formula | Excel Worksheet Functions | |||
Working time and days | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) | |||
Simple formulas in existing Excel 2002 no longer working. | Excel Worksheet Functions |