LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
michaell
 
Posts: n/a
Default how to make this work if sum=5+n2 then sum becomes the value of s.

I want to get or create a formula in excel or access that allows me to keep a
running total of my supplies ie... I have 2 pens, remove one and receive 2.
answer in the cell becomes 3 pens then if I zero out the received cell the
inventory cell still remembers that I have 3 pens not 4 pens (because I
received 2 more pens) and visa versa when I zero out the received cell it
remembers I have 3 pens not 1 pen(because I removed 1 pen)
 
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 do I make 'save as web page' with interactivity work properly. Giasemi Charts and Charting in Excel 0 January 6th 05 03:51 PM
make hidden window or workbook visible without specify the name mango Excel Worksheet Functions 1 December 30th 04 03:05 PM
How do I make this formula work =if(a1=(b10:b20),"good","bad"). AK Excel Worksheet Functions 2 December 2nd 04 01:13 AM
Change Path names in copied work book jheaney Excel Worksheet Functions 2 November 18th 04 07:29 PM
How do I make an If-Then formula in Excel? kdub1980 Excel Worksheet Functions 3 November 11th 04 06:08 AM


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