LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
szelinko
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
click & drag not working Teresa Excel Discussion (Misc queries) 2 February 25th 06 01:52 AM
Help with what should be a simple formula B Millar via OfficeKB.com Excel Worksheet Functions 2 June 16th 05 04:18 PM
Working time and days Nortos Excel Worksheet Functions 5 May 6th 05 04:17 PM
Working time and days Nortos Excel Discussion (Misc queries) 1 May 6th 05 03:47 PM
Simple formulas in existing Excel 2002 no longer working. AllieB Excel Worksheet Functions 3 May 3rd 05 04:14 PM


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"