Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to be able to load a spreadsheet up and in a cell be able to count
the amount of times I press recalc (F9 or any other way).........why I've set a simple model up to simulate a slot machine, so I need to know each time the machine is used........in order to calculate the monie spent. I want to also know how I can hold the output money figure generated and each time the recalc buton is pressed then add the values together (all winnings are added together, if I just reference the cell it only displays the current value.......in simple terms I want to add the winning each time to give a running total Many Thanks Steve |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Steve,
http://www.mcgimpsey.com/excel/accumulator.html -- Kind regards, Niek Otten Microsoft MVP - Excel "$T3V3" wrote in message ... |I want to be able to load a spreadsheet up and in a cell be able to count | the amount of times I press recalc (F9 or any other way).........why I've set | a simple model up to simulate a slot machine, so I need to know each time the | machine is used........in order to calculate the monie spent. | | I want to also know how I can hold the output money figure generated and | each time the recalc buton is pressed then add the values together (all | winnings are added together, if I just reference the cell it only displays | the current value.......in simple terms I want to add the winning each time | to give a running total | | Many Thanks | Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I use the "Small Caps" Font option in an Excel speadsheet | Excel Discussion (Misc queries) | |||
Excel automatically creates a backup speadsheet | Excel Discussion (Misc queries) | |||
Open an existing excel speadsheet, opens Excel but not the file?? | Excel Discussion (Misc queries) | |||
how do you open an email attachment that is an excel speadsheet w. | Excel Discussion (Misc queries) | |||
how do I protect a formula in an excel speadsheet | Excel Worksheet Functions |