IF(AND)
.....wrong post!!!
"Toppers" wrote:
Try:
=MOD((B1-A1),1)*24
HTH
"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.
|