Excel 2003 and a basic subtraction formula

[Saral6978]

Okay - I am SO not an Excel person. Here is a small example of what I am
trying to do:

F12=SUM(F11-E12)

So basically, you put in a value in E12 and then F12 will give you the
remaining number. It looks like it should work, but when I attempt to add a
number in E12, the calculated number does not appear in F12.

Frankly, I know next to nothing about Excel formulas except for adding them
using the SUM symbol, that's about it. Anyone have any suggestions as to
what I'm missing. The spreadsheet was working fine before Office was
upgraded from XP to 2003.

Thanks,

Sara

 

[Gordon]

Okay - I am SO not an Excel person. Here is a small example of what I am
trying to do:

F12=SUM(F11-E12)

So basically, you put in a value in E12 and then F12 will give you the
remaining number. It looks like it should work, but when I attempt to add
a
number in E12, the calculated number does not appear in F12.

Frankly, I know next to nothing about Excel formulas except for adding
them
using the SUM symbol, that's about it. Anyone have any suggestions as to
what I'm missing. The spreadsheet was working fine before Office was
upgraded from XP to 2003.

Thanks,

Sara

Take out the "SUM" part of the formula, and the brackets.

 

[DL]

Same difference but;
in F12 type, =
Then with the mouse, click F11 cell
Type, -
Then with mouse click E12 cell
Lastley click the tick icon next to the formulae bar

 

[Saral6978]

Well, originally the forumul was =F11-E12, but that wasn't working, so
another user suggested the SUM and the brackets...

 

[Gordon]

Well, originally the forumul was =F11-E12, but that wasn't working, so
another user suggested the SUM and the brackets...

No reason why that formula shouldn't work - what result did it give? (I
assume that there are values in both F11 and E12.....)

 

[Gordon]

Well, originally the forumul was =F11-E12, but that wasn't working, so
another user suggested the SUM and the brackets...

Well a "SUM" formual should look like =SUM(F11:E12) and will add (that's
what SUM means) ALL the values in the cells between F11 and E12.....

 

[Saral6978]

I'll try this...thanks!

Same difference but;
in F12 type, =
Then with the mouse, click F11 cell
Type, -
Then with mouse click E12 cell
Lastley click the tick icon next to the formulae bar

 

[Saral6978]

Actually, what's the "tick icon"? What does it look like exactly?

 

[DL]

When you type, = , in a cell a further tool bar will open, just above the
excel grid, its the Formulae tool bar, to its left is a 'tick' & 'X' icons.
The Formulae edit bar will show; = (you can type in this portion your actual
formulae)
eg if you use the mouse to select your cells, in this case it will show "=
F11 - E12"
By clicking the 'tick' icon your are excepting the formulae ( X will cancel)

 

[Saral6978]

Okay - well, not sure what the heck happened but it is working. I sent a
copy of the spreadsheet to a co-worker who is sort of a whiz at Excel. He
opened the spreadsheet (without making any changes), changed a # in the E
column (to see the problem) and the change was reflected in the F column!!
It worked just fine for him! He then forwarded me the worksheet back, I
opened it and it now worked for me too! The original creator of the
spreadsheet is now able to open the same document after I sent it back to
her. All 3 of us are running Excel 2003. Why on earth would it work right
off the bat for him and not myself or the original file owner? Doesn't make
any sense, but at this point, I guess the problem is resolved.

 

[rvishwakarmaster]

Dear Sir/ Madam

How to use date & time and logical formula.

Please reply me very soon.....

Thanking you in anticipation

Ravi Vishwakarma