Trouble constructing IF statement
 

I am trying to display one of two results in a cell depending on the results
of several True / False tests.

If both "A AND B" are true or if "C" is true I want to display the results
of the same formula. If neither "A AND B" or "C" are true I want the cell to
be blank.

I am getting an error message on the "logical test" of my first IF statement
which currenly looks like

=IF(((D1415) AND (G14="Y")),((I14*N14)/12),IF(C14.8,((I14*N14)/12),""))

Any suggestion on correcting the error in the equation or offering a
different way to successfully achieve the results I am looking for will be
appreciated.
--
Joe Schwartz

Trouble constructing IF statement
 

Try it like this:

=IF(OR(AND(D1415,G14="Y"),C140.8),I14*N14/12,"")

--
Biff
Microsoft Excel MVP


"Joe" (donotspam) wrote in message
...
I am trying to display one of two results in a cell depending on the
results
of several True / False tests.

If both "A AND B" are true or if "C" is true I want to display the results
of the same formula. If neither "A AND B" or "C" are true I want the cell
to
be blank.

I am getting an error message on the "logical test" of my first IF
statement
which currenly looks like

=IF(((D1415) AND (G14="Y")),((I14*N14)/12),IF(C14.8,((I14*N14)/12),""))

Any suggestion on correcting the error in the equation or offering a
different way to successfully achieve the results I am looking for will be
appreciated.
--
Joe Schwartz