| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF(AND)
Just checked, it's set to automatic.
"Dave Peterson" wrote: Do you have calculation set to manual? Check under tools|Options|Calculation tab. Try making it automatic. DJ wrote: 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. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
