Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to have a "IF, Then" formula for the scenario where you have
3 variables such as: If A OR B is true AND C is False then 8 otherwise 0. Either A or B can be true, but C must always be true for the formula to return 8, otherwise it would return 0. My specific formula is =IF(G32=R10,0,IF(OR(C32<C7,C32C8),IF(AND(R32=FALS E),R10,0))) The result I get is FALSE. I am looking for the value in R10 which is 8 or 0 (that is zero). In this case I was expecting a zero. How do I write an If ORAnd combination? Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If Statement with Two Different Logical Test | Excel Worksheet Functions | |||
Explaination of Logical If Then Statement | Excel Worksheet Functions | |||
Logical statement for 'contains' ? | Excel Discussion (Misc queries) | |||
Logical Statement | Excel Discussion (Misc queries) | |||
3 logical condition if statement | Excel Worksheet Functions |