IF(AND)
Options:
AC3: =VALUE(Left(M3,2))
AD3: =IF(G3="G1",1,IF(G3="G2",2,IF(G3="G3",3,IF(G3="Stk ",4))))
OR
leaving AC3/AD3 unchanged:
=IF(AND(VALUE(AC3)=1,VALUE(AD3)=3),6,0)
HTH
"DJ" wrote:
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
|