Lost and Completely frustrated
 

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?!?

Lost and Completely frustrated
 

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?!?

Lost and Completely frustrated
 

Hi

I don't understand how your table 0.

What formula needs to stop?

Lost and Completely frustrated
 

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?

Lost and Completely frustrated
 

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.

Lost and Completely frustrated
 

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?