Ok, that has to be it then. But, I'm at a loss to how to fix it. Even though
the results in AC3 and AD3 are numbers, they are showing up as if they were
text, i.e. in the left side of the cell instead of the right. Maybe it has to
do with the formulas for each of the cells? AC3 is =LEFT(M3,2) and AD3 is
=IF(G3="G1","1",IF(G3="G2","2",IF(G3="G3","3",IF(G 3="Stk","4")))) Or because
the cells that those formulas are pulling their info from are "text" cells.
Hmmmm...I have no idea. Shouldn't the original formula work even if it were
text as long as the answers match to each part of the formula? I don't know,
just thinking out loud...

"Jim May" wrote:

Your formula works for me;
Check your formatting in all 3 cells.

"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.