Lost and Completely frustrated

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

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...
 
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...
 
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
 
Back
Top