Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Testing for conditions with IF statement and AND function
I am having trouble displaying varying results in a cell depending on what
conditions exist. I have three conditions. If conditions A and B are both true or if condition C is true, I want the cell to display the same results. If neither "A and B" or C are true, I wan the sell to be blank. I am getting an error message with the "logical test" of my IF statement and I don't know another way to create the desired results. Here is the formula as I have written it =IF(((D1415) AND (G14="Y")),((I14*N14)/12),IF(C14.8,((I14*N14)/12),"")) Any ideas? -- Joe Schwartz |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Testing for conditions with IF statement and AND function
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 having trouble displaying varying results in a cell depending on what conditions exist. I have three conditions. If conditions A and B are both true or if condition C is true, I want the cell to display the same results. If neither "A and B" or C are true, I wan the sell to be blank. I am getting an error message with the "logical test" of my IF statement and I don't know another way to create the desired results. Here is the formula as I have written it =IF(((D1415) AND (G14="Y")),((I14*N14)/12),IF(C14.8,((I14*N14)/12),"")) Any ideas? -- Joe Schwartz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditions with IF statement | Excel Discussion (Misc queries) | |||
Does excel have a function for statistical hypotosis testing? | Excel Worksheet Functions | |||
IF function....testing against values in multiple cells | Excel Worksheet Functions | |||
Testing for Multiple Conditions | Excel Discussion (Misc queries) | |||
testing more than one variable in an if statement | Excel Discussion (Misc queries) |