Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hopefully, someone can point me in the right direction here. I have entered
the following eqaution into one of my sheets... =IF(AND(AC3=1,AD3=3),6,0) Now, even when AC3=1 and AD3=3, I'm still getting 0 as the result when I want it to be 6. I actually have 12 different combos to test for, but I'm trying to get just one working right now. I'll cross that other bridge when I manage to get past this one. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Possible to combine VLOOKUP and IF(AND) functions? | Excel Worksheet Functions | |||
IF(AND function is not working | Excel Worksheet Functions | |||
If(And for Conditional Formating | Excel Worksheet Functions | |||
nested if(and) functions | Excel Discussion (Misc queries) | |||
My IF(AND passes logical, but doesn't reveal correct results | Excel Worksheet Functions |