I am working with three tables. In the third table I am attempting to create
an "if" formula that will change the equation twice.

Essentially, when table one <0, then I have to stop doing part of the
formula in table 3, and when table two <0, then I have to stop doing a
different part of the formula.

Both of these can be <0 at the same time or at different times but the
formula changes depending so I wouldn't say that I need an "and" or an "or"
formula in it.

Any suggestions?!?

You need to add IF formula to the section you want to perfrom or not based on
the conditon...

=IF(condition, true do this, false do this)
You need to take care of the value IF returns so that the formula works...



"Stephanie" wrote:

I am working with three tables. In the third table I am attempting to create
an "if" formula that will change the equation twice.

Essentially, when table one <0, then I have to stop doing part of the
formula in table 3, and when table two <0, then I have to stop doing a
different part of the formula.

Both of these can be <0 at the same time or at different times but the
formula changes depending so I wouldn't say that I need an "and" or an "or"
formula in it.

Any suggestions?!?

Hi

I don't understand how your table 0.

What formula needs to stop?

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?

Stephanie

It will help us if we knew what the IF() formula looks like.

Post it and we can try & do a work-through.


mark.

You again set a table to a value. What do you mean when you say bd<0 when
bd is a table? A cell can have a value but not the whole table. HTH Otto
"Stephanie" wrote in message
...
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?