Excel Formula: Value + Value + 1

  • Thread starter Thread starter thorvision
  • Start date Start date
T

thorvision

I'm looking to avoid writing VBA code; I've got a random numbe
generator in let's say, A1. I want to create a formula that perform
NewValue = OldValue + 1 . (Essentially, accumulate the changing rando
value and add 1 to it) As an alternative, how do I accumulat
(totalizer) for all the random values created by excel
 
As I understand it, you want to create a running total? That is, takin
the random value in A1, and adding it to all the other random values s
far generated.

So,

A1 generates to 6,
B1 = 6.
Refresh, A1 generates to 3
B1 = 9
Refresh, A1 generates to 4
B1 = 13

Is that what you're trying to do? If so, as far as I know (with m
limited knowledge) you'll have to use VBA, although very very ligh
VBA.

If that isn't what you're trying to do, apologies, I misunderstood.

-Bo
 
Back
Top