My apologies, when I get frustrated, parts of my brain stop working. I have
tried the IF statment but it doesn't seem to be working because of the
complexity. However, I could just be losing my mind and don't know what i'm
doing. I did manage to get a simpler IF statment working before but maybe
I'm just trying to work excel to hard ha-ha. I guess I am wondering if there
is any way I can add two or three IF statments together in one function??

For instance, lets call table 1 bd and table 2 gd.

In table three, I am using a monthly debit and a monthly credit. If bd <0,
I want to drop the debit, and if gd<0, I want to drop the credit. Both bd
and gd could be <0 at the same time or seperately.

Wow, I think I have just confused myself...

"dan dungan" wrote:

Hi

I don't understand how your table 0.

What formula needs to stop?