You can replace your =IF((H3*(1+$O$43))<0, 0, H3*(1+$O$43)) by
=MAX(H3*(1+$O$43),0).
I don't understand how that formula relates to your discussion of deducted
amount, column value, and incremental.
--
David Biddulph

Michael Cook wrote:
I am trying to build a worksheet that deducts a value from each cell
in a column in a row until the column equals zero and then begins
deducting from another column when there is a zero value in the
original column with the general if equation =IF((H3*(1+$O$43))<0,
0, H3*(1+$O$43)). The problem I run into is that if the deducted
amount is for instance 600K and the column value is 400 K the
incremental 200K never gets accounted for which should have been
deducted from column 2.
I am using Excel 2003