You keep saying "subtract from D5" or "subtract from E5" which sounds like you
want those values reduced.

I don't understand that part.

Sounds like you want D5 or E5 to change without changing.

See Roger's answer for using a couple of helper cells.

Maybe that's what you need.


Gord


On Thu, 5 Jul 2007 10:04:02 -0700, Craigallen
wrote:

I don't want the values in D5 or E5 to change; what I would like is a formula
in A2 that looks at D5 first and subtracts from D5 as much as needed to cover
the amount in A1, but if there's not enough, the formula in A2 would then
look at E5 for the balance. So let's say A1 has $300 in it; and let's say
there is $500 in D5; the formula would look at D5 and see that there is
enough in D5, so it would simply subtract $300 from D5, leaving a balance of
$200. But, if there was $550 in A1, then the formula would look at D5 and
see that there was only $500 there, so it would subtract the $500, and then
look to E5 for the other $50. I realize I may need formulas in more than
just A2 in this example to accomplish this. So, is there a combination of
formulas that would work?