Hi Jane

If I understood you correctly, try the following (all one line).

=IF(OR(K2<1,H17<1,$K$3="N"),0,
IF(AND(INT(F17)=1,INT(F17)<=3),$K$5,
IF(AND(INT(F17)=4,INT(F17)<=6),$L$5,
IF(AND(INT(F17)=7,INT(F17)<=10),$M$5,
0))))


--
XL2002
Regards

William



"Jane" wrote in message
...
| I wasn't able to do a print screen but here is what I am trying to do:
|
| if k2 = "1" and h17 also = "1" and if K3 does not equal "N" AND if F17
| equals either 1, 2, or 3, then give result of 18 BUT IF k2 = "1" and h17
| also = "1" and if cell K3 does not equal "N" AND if F17 equals either 4,
5,
| or 6, then give result of 12 BUT IF k2 = "1" and h17 also = "1" and if
| cell K3 does not equal "N" AND if F17 equals either 7, 8, 9, or 10, then
give
| result of 6.
|
| my absolute cells are in row 3: K3 thru T3... K3=1, L3=2, m3=3, and so on
| my other absolute cells are in row 5: K5 thru M5
|
|
|
'=IF(AND(K$2=1,H17=1,K$3<"n"),IF(OR(F17=1,F17=2,F 17=3),K$5)+IF(OR(F17=4,F17
=5,F17=6),L$5)+IF(OR(F17=7,F17=8,F17=9,F17=10),M$5 ))+ ... etc.
| see full formula below:
|
|
'=IF(AND(K$2=1,H17=1,K$3<"n"),IF(OR(F17=1,F17=2,F 17=3),K$5)+IF(OR(F17=4,F17
=5,F17=6),L$5)+IF(OR(F17=7,F17=8,F17=9,F17=10),M$5 ))+IF(AND(L$2=2,H17=2,L$3<
"N"),IF(OR(F17=1,F17=2,F17=3),K$5)+IF(OR
|
(F17=4,F17=5,F17=6),L$5)+IF(OR(F17=7,F17=8,F17=9,F 17=10),M$5))+IF(AND(M$2=3,
H17=3,M$3<"N"),IF(OR(F17=1,F17=2,F17=3),K$5)+IF(O R(F17=4,F17=5,F17=6),L$5)+
IF(OR(F17=7,F17=8,F17=9,F17=10),M$5))+IF(AND(N$2=4 ,H17=4,N$3<"N"),IF(OR(F17
=1,F17=2,F17=3),K$5)+IF(OR(F17=4,
|
F17=5,F17=6),L$5)+IF(OR(F17=7,F17=8,F17=9,F17=10), M$5))+IF(AND(O$2=5,H17=5,O
$3<"N"),IF(OR(F17=1,F17=2,F17=3),K$5)+IF(OR(F17=4 ,F17=5,F17=6),L$5)+IF(OR(F
17=7,F17=8,F17=9,F17=10),M$5))+IF(AND(P$2=6,H17=6, P$3<"N"),IF(OR(F17=1,F17=
2,F17=3),K$5)+IF(OR(F17=4,F17=5,F17=6),L$5)+IF(OR( F17=7,F17=8,F17=9,F17=10),
M$5))+IF(AND(Q$2=7,H17=7,Q$3<"N"),IF(OR(F17=1,F17 =2,F17=3),K$5)+IF(OR(F17=4
,F17=5,F17=6),L$5)+IF(OR(F17=7,F17=8,F17=9,F17=10) ,M$5))+IF(AND(R$2=8,H17=8,
R$3<"N"),IF(OR(F17=1,F17=2,F17=3),K$5)+IF(OR(F17= 4,F17=5,F17=6),L$5)+IF(OR(
F17=7,F17=8,F17=9,F17=10),M$5))+IF(AND(s$2=9,H17=9 ,s$3<"N"),IF(OR(F17=1,F17
=2,F17=3),K$5)+IF(OR(F17=4,F17=5,F17=6),L$5)+IF(OR (F17=7,F17=8,F17=9,F17=10)
,M$5))+IF(AND(t$2=10,H17=10,t$3<"N"),IF(OR(F17=1, F17=2,F17=3),K$5)+IF(OR(F1
7=
| 4,F17=5,F17=6),L$5)+IF(OR(F17=7,F17=8,F17=9,F17=10 ),M$5))
|
| THANK YOU IN ADVANCE FOR YOUR HELP!! jane
|
| "Jane" wrote:
|
|