Excel Speadsheet

[Guest]

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

 

[Niek Otten]

Hi Steve,

http://www.mcgimpsey.com/excel/accumulator.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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