Formula stopped working - need experts help!
 

OK - am having problem with this and need expert help.
1) When I try to change the $250 in the last column, it does not work and
2) When I go to the next line and add $100 - it goes back to $100 balance
and takes nothing before it into consideration.

Am a newbie to Excel and really need some help!
Thanks!

Formula stopped working - need experts help!
 

Pls do NOT attach files here. But, since you did, I took a look. You will be
embarrassed to find that you only have values in the last three rows.
Perhaps you should copy down from three rows above........... Just a
thought.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terri" wrote in message
...
OK - am having problem with this and need expert help.
1) When I try to change the $250 in the last column, it does not work and
2) When I go to the next line and add $100 - it goes back to $100 balance
and takes nothing before it into consideration.

Am a newbie to Excel and really need some help!
Thanks!

Formula stopped working - need experts help!
 

Don:

Copy what where???

I am totally ignorant in Excel..


"Don Guillett" wrote in message
...
Pls do NOT attach files here. But, since you did, I took a look. You will
be embarrassed to find that you only have values in the last three rows.
Perhaps you should copy down from three rows above........... Just a
thought.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terri" wrote in message
...
OK - am having problem with this and need expert help.
1) When I try to change the $250 in the last column, it does not work and
2) When I go to the next line and add $100 - it goes back to $100 balance
and takes nothing before it into consideration.

Am a newbie to Excel and really need some help!
Thanks!

Formula stopped working - need experts help!
 

Obviously, look at the last three cells to see that they have been changed
from formulas and just go up to where you do see a formula and copy down
using the fill handle. Oops. Guess you won't be able to get that, so copy
that cell select the other three cellspaste.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terri" wrote in message
...
Don:

Copy what where???

I am totally ignorant in Excel..


"Don Guillett" wrote in message
...
Pls do NOT attach files here. But, since you did, I took a look. You will
be embarrassed to find that you only have values in the last three rows.
Perhaps you should copy down from three rows above........... Just a
thought.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terri" wrote in message
...
OK - am having problem with this and need expert help.
1) When I try to change the $250 in the last column, it does not work
and
2) When I go to the next line and add $100 - it goes back to $100
balance and takes nothing before it into consideration.

Am a newbie to Excel and really need some help!
Thanks!

Formula stopped working - need experts help!
 

Don:

I have tried everything for hours and cannot figure this out - it is
impossible....no matter what UI try does not work and I need this in shape
for Monday.


"Don Guillett" wrote in message
...
Obviously, look at the last three cells to see that they have been changed
from formulas and just go up to where you do see a formula and copy down
using the fill handle. Oops. Guess you won't be able to get that, so copy
that cell select the other three cellspaste.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terri" wrote in message
...
Don:

Copy what where???

I am totally ignorant in Excel..


"Don Guillett" wrote in message
...
Pls do NOT attach files here. But, since you did, I took a look. You
will be embarrassed to find that you only have values in the last three
rows. Perhaps you should copy down from three rows above........... Just
a thought.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terri" wrote in message
...
OK - am having problem with this and need expert help.
1) When I try to change the $250 in the last column, it does not work
and
2) When I go to the next line and add $100 - it goes back to $100
balance and takes nothing before it into consideration.

Am a newbie to Excel and really need some help!
Thanks!

Formula stopped working - need experts help!
 

I sent her a file.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terri" wrote in message
...
Don:

I have tried everything for hours and cannot figure this out - it is
impossible....no matter what UI try does not work and I need this in shape
for Monday.


"Don Guillett" wrote in message
...
Obviously, look at the last three cells to see that they have been
changed from formulas and just go up to where you do see a formula and
copy down using the fill handle. Oops. Guess you won't be able to get
that, so copy that cell select the other three cellspaste.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terri" wrote in message
...
Don:

Copy what where???

I am totally ignorant in Excel..


"Don Guillett" wrote in message
...
Pls do NOT attach files here. But, since you did, I took a look. You
will be embarrassed to find that you only have values in the last three
rows. Perhaps you should copy down from three rows above...........
Just a thought.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Terri" wrote in message
...
OK - am having problem with this and need expert help.
1) When I try to change the $250 in the last column, it does not work
and
2) When I go to the next line and add $100 - it goes back to $100
balance and takes nothing before it into consideration.

Am a newbie to Excel and really need some help!
Thanks!