Formula to find difference with changing initial number?

Hi, I am struggling to find a formula that would work. I have a row of data and the first cell is fixed. I put in a number in the cell next to it and need to subtract the fixed data.. That bit is easy. However, I then add a new number and need the formula to use this instead to subtract the fixed number from.
For example A1 would be 6.3. B1 would be 7.2 and produce an answer in cell F1. Then new data is out into C1 so now the formula needs to use C1-A1 and so on. Does this make any sense and is it possible? Thanks

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

If I understand, it almost sounds like you need to understand how to make a cell reference absolute: http://office.microsoft.com/en-us/ex...es_in_formulas

Perhaps in your case =B1-$A$1 The reference to B1 will change as the formula is copied, but the reference to A1 will stay fixed.

I must not understand.

You need a cell formula that will subtract two cells. It needs to be able to recognize when you enter a value in a cell adjacent to the currently used cells and automatically adjust its reference to the newly entered cell? In accomplishing this, you do not want to simply copy the formula over to match the entered cell?

Can you upload a sample spreadsheet? Can you explain in better detail what you need this to do?