Results 1 to 7 of 7
Thread: Excel
Hybrid View
-
16th March 2011 17:52 #1
Excel
:
E5 B16:B19 B5 - , B5. "26", "3" . , . E5 B5 -, ... [250000-25999], , . , , ( IF-, ). ? IF OR , - IF, ?
-
16th March 2011 19:13 #2
E5 =vlookup(B5,$A$16:$B$19,2)
($- A16:B19 5 6, 7 . B5, B6, B7...)Last edited by ined; 16th March 2011 at 19:56.
ASRock B85 Pro4, Pentium G3240, DD3 8GB/1333MHz, 120GB SSD + 1TB + 640GB HDD
Gigabyte GV-R657OC-1GI, CM B500, ASUS 24B1S1, LCD SAMSUNG SM931BW, 173
-
16th March 2011 19:52 #3
-
16th March 2011 20:35 #4
-
16th March 2011 20:41 #5
, , ? , averageif... Average , averageif? , ...
-
16th March 2011 21:15 #6
Excel 2003, averageif.
2003 verage - , averagea .ASRock B85 Pro4, Pentium G3240, DD3 8GB/1333MHz, 120GB SSD + 1TB + 640GB HDD
Gigabyte GV-R657OC-1GI, CM B500, ASUS 24B1S1, LCD SAMSUNG SM931BW, 173
-
11th September 2011 21:50 #7Registered User
Join Date: Sep:2010
Location:
Posts: 13
EXCEL 2007
,
:
G2 - ,
, 20-2 , 18
J2 18. , G2 ,
2. , ,
3.
4. C2 - 2 D2 , 1 1,50
vllookup , , - .. .
,
if and, . :
-if(and(D2=),(E2=)),2,if(and(D2= ),(E2=)),1,if(and(D2=),(E2 =)),1,50,0)
, ?
http://dox.bg/files/dw?a=48fda249a3




Reply With Quote

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