Please, advice a more elegant/correct approach to fill the column with values

Originally Posted by Richard Buttrey

Hi,

One way in D3 copied down

Formula:

=IF(D2>0,-D2*$B$1,$E1+D2)

Ah, indeed. ) Seems I got too enamored with the OFFSET function. Thank you.