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