Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with an IF statement. | Excel Discussion (Misc queries) | |||
If statement trouble | Excel Worksheet Functions | |||
Constructing graphs in excel | Charts and Charting in Excel | |||
Help constructing simple spreadsheet | New Users to Excel | |||
Trouble with a conditional statement | New Users to Excel |