continue a number if less then previous

[Frank]

Any way to continue a number if the result of some calculation yields a
result smaller then (= to leave a lone) the previous cell?

example:

8
8
9
10
0 - want this cell to be 10 not zero. The resulting calculation makes
it zero but I would like to continue the 10

 

[Bob Phillips]

Frank,

In A2:
=(IF(my_formula=0,A1,my_formula)

and copy down.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank]

Thanks that worked!