Results 1 to 5 of 5
Thread: EXCEL 2003
Hybrid View
-
16th March 2009 17:01 #1
EXCEL 2003
... OR AND ?
:
=IF(AND(OR(B5=J1;B5=K1);B8=L1);L3;IF(AND (OR(B5=J1;B5=K1);B8=M1);M3;IF(AND(OR(B5= J1;B5=K1);B8=N1);N3;IF(AND(OR(B5=J1;B5=K 1);B8=O1);3;IF(AND(OR(B5=J1;B5=K1);B8=P1 );P3;IF(AND(OR(B5=J1;B5=K1);B8=Q1);Q3;IF (AND(OR(B5=J1;B5=K1);B8=R1);R3;0)))))))
highlight- - OR.
IF - ( OR-a) ! ->
=IF(AND(OR(B5=J1;B5=K1);B8=L1);L3;IF(AND (OR(B5=J1;B5=K1);B8=M1);M3;IF(AND(OR(B5= J1;B5=K1);B8=N1);N3;IF(AND(OR(B5=J1;B5=K 1);B8=O1);3;IF(AND(OR(B5=J1;B5=K1);B8=P1 );P3;IF(AND(OR(B5=J1;B5=K1);B8=Q1);Q3;0) )))))
( )... OR , !
?
-
16th March 2009 17:08 #2Banned
Join Date: Jun:2008
Location:
Posts: 1,880
Excel 7 .
-
16th March 2009 17:41 #3
-
16th March 2009 18:47 #4
-
16th March 2009 20:27 #5
=IF(OR(B5=J1;B5=K1);HLOOKUP(B8;L1:R3;3;F ALSE);0)
, B5=J1 B5=K1, B8 L1 R1 ( ) #N/A 0. , -
=IF(AND(OR(B5=J1;B5=K1);(NOT(ISNA(HLOOKU P(B8;L1:R3;3;FALSE)))));HLOOKUP(B8;L1:R3 ;3);0)!




Reply With Quote

R9 280,
7th May 2023, 21:28 in