Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 17
Default 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!




  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,124
Default 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!



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 17
Default 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!





  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 17
Default 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!










  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,124
Default 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!









Reply
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
F4 Function Key stopped working Javier Excel Worksheet Functions 3 March 26th 08 07:23 PM
formula stopped working.... Ken Proj mgr Excel Discussion (Misc queries) 5 December 29th 06 03:57 PM
Web query has stopped working... andrewm27 Excel Discussion (Misc queries) 0 April 20th 06 05:28 AM
VB Stopped Working [email protected] Excel Worksheet Functions 1 April 28th 05 01:56 PM
excel 97 stopped working john f Excel Worksheet Functions 1 April 13th 05 11:52 PM


All times are GMT +1. The time now is 10:55 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"