View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default 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?!?