Thread: IF(AND)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dj dj is offline
external usenet poster
 
Posts: 92
Default IF(AND)

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.