continue a number if less then previous

  • Thread starter Thread starter Frank
  • Start date Start date
F

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
 
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)
 
Back
Top