LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 390
Default Input dollar amount into a cell that updates another cell and more

Help!

I am racking my brain trying to figure out how to input a dollar figure into
a cell (A1)that updates another cell (A2) with the running total (easy to do)
but the hard part is when you want to add in the next dollar figure in the
same cell (A1) but you want to increase the value in A2 by this new number.

Why do I want to do this?

I have created a spreadsheet for a game and instead of using paper money I
want to be able to increase or decrease the player's dollar amount by having
the player (knows nothing about excel) input the dollar amount they want to
either increase or decrease their running total by and I want to keep it
simple for the player so they do have to add formulas when they enter the new
dollar figure.

Hope this makes sense?
 
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
How to use a name to represent a dollar amount Item Manager Excel Discussion (Misc queries) 1 May 6th 08 08:20 PM
subsetting by dollar amount ChuckW Excel Discussion (Misc queries) 3 April 24th 08 03:19 AM
sales tax total amount from one cell amount to another cell ROSIEMSM Excel Discussion (Misc queries) 1 May 19th 07 03:15 PM
make a letter in a cell automatically equal a dollar amount kimzim Excel Discussion (Misc queries) 1 August 17th 05 08:26 PM
Hide row if dollar amount is zero Karl Irvin Excel Discussion (Misc queries) 5 May 7th 05 12:08 AM


All times are GMT +1. The time now is 04:12 AM.

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"