Hi everyone.

First time poster here, but i have read through alot of threads and i cant seem to find an answer that can help me, so i thought i join up and become an active member :)

Ill cut straight to the point

I am at an intermediate level with excel, and i was wondering if my following problem can be solved, ill give a basic run-down, and if anymore detail is required please let me know

After a few caculations etc etc i have 2 cells left that i need to get the following to happen

I will call them A and B

A has an amount which could be negative or positive.
B always starts with 3000 (could be 4000 or anything else later on, but for all purposes 3000 is fine)

Is there a way so that if A is ever a negative, i can have an amount taken from B to bring A back to zero.

If A is positive, nothing would be done, but if A was -345.32 for example, that exact amount is taken from B

That is the most direct description i can give, but if more info is reequired just let me know, because there possibly might be a way around this with another column or two to bypass this

And help would be great

Thanks in advance