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