ȸ
|
μ | ǻȰɷ | óɻ
| Ȱ | | Ʈ | ũ/VBA | ǹ
OA α׷ | | ڰ | Ÿ
α
йȣ
 ڵȭ
 ڵȭ
 ǹȰ
㼭
 ȸ 湮     8,351,586   
  ο     4,002   
  Ȩ > ڵȭ > ڵȭ     

(Hit: 59,614) Ȯ   μ  
ٿε
 ̿().xls
 ̿(ϼ).xls
ҵ漼 꼭 ؾ Ը 꼭 ϰ ŷ ϱ Դϴ. ⿡ ۼϴ "Է" Ʈ ŷó ۼ, ŷ Էϸ "" Ʈ 2 ڵ ۼǵ Դϴ. ٷ ִ ϼ ϰ ִ մϴ.

≮1>

≮2>


1) ŷ Էϰ ̸

* ̸

[Է] ũƮ [] ũƮ ϼϱ ʿ ⺻ Էϱ ̴. Ÿ ͸ Էϰ ߿ ͸ ̸ ϴ Ѵ.

[C4] ŷó, [C5] ۼڸ ԷѴ. [C5] ¥ ǥ ̸ Ǿ ִ.

   

[B8:B22] ŷ, [C8:C22] ǰ, [D8:D22] , [E8:E9] ܰ ԷѴ.

[F8:F22] ϰ =IF(OR(D8="",E8=""),"",D8*E8) Է [Ctrl+Enter] ݾ Ѵ.

     

OR Լ

OR(1,2,...)

ϳ ̻ ̸ OR Լ TRUE ȴ. OR Լ FALSE ȴ.

м

OR(D8="",E8="")

(D8) ְų ܰ(E8) TRUE ȯѴ. ܰ ԷµǾ FALSE ȯѴ.

=IF(OR,"",D8*E8)

OR Լ TRUE̸ () ǥϰ, OR Լ FALSE̸ , ܰ ԷµǾ (D8) ܰ(E8) ؼ ݾ Ѵ.

[F4] =SUM(F8:F22) Էؼ ݾ հ踦 Ѵ. [F5] ʿ Ƿ ԷѴ. ⼭ ƹ ͵ Է ʾҴ.

[B4:C5] ϰ [Ctrl] ¿ [E4:F5] Ѵ. ׷ [][̸][] ޴ Ѵ.

   

[̸ ] ȭڿ [ ] ׸ ϰ [Ȯ] ŬѴ. ̷ ϸ ؽƮ Ű ̸ ǵȴ.

   

[B7:F22] ϰ [][̸][] ޴ Ѵ.

[̸ ] ȭڿ [ù ] ׸ ϰ [Ȯ] ŬѴ. ̷ ϸ ̸ ù ࿡ ִ ؽƮ ǵȴ.

   

[̸ ] ȭǥ ߸ Ŭϸ [] ̸ Ȯ ִ. ̸ Ͽ ϳ Ŭϸ ش ̸ ϴ Ǵ õȴ.

   

2) ޹޴ڿ ϱ

* INDEX Լ

[Է] ũƮ Է [] ũƮ ޹޴ڿ INDEX Լ Ѵ. INDEX Լ ȣ ؼ Ư Ѵ.

[] ũƮ [E6] =ŷó ԷѴ. ׷ [ŷó] ̸ [Է] ũƮ [C4] Է ״ ǥõȴ.

   

Ϲȣ ȣ, ޹޴ڿ Էϴ Ѵ.

[B15] , [F15] =հݾ, [M15] = Էؼ ̸ ̸ ״ ǥѴ. ࿡ ش Ͱ ԷµǾ 0 ǥõȴ.

     

[B18:C32] ϰ =INDEX(,ROW(A1)) Է [Ctrl+Enter] .

      

ROW Լ

ROW()

ȣ Ѵ. ϸ ROW Լ Է ȣ Ѵ.

INDEX Լ

INDEX(,,)

־ , ȣ شǴ Ư Ѵ.

INDEX(,ȣ)

ϳ ̳ ϳ Ǿ ִ ־ ȣ شϴ Ѵ.

м

ROW(A1)

[A1] ȣ 1 Ѵ. [B18] ROW(A1) [B19] ROW(A2) ǹǷ ȣ 2 Ѵ.

=INDEX(,ROW(A1))

[] ROW Լ شϴ ġ Ѵ. [B18] ROW 1̹Ƿ [] 1° ִ , [B19] ROW 2̹Ƿ [] 2° ִ ´.

[B18:B32] ϰ [][] ޴ ؼ [ ] ȭڸ Ÿ. [ǥ ] ǿ [] [ ] ϰ, [] M Է [Ȯ] ŬѴ. ׷ ǥ ִ.

[C18:C32] Ͽ D Ѵ. ׷ ϸ ǥõȴ.

   

ǰ , ܰ, ޴밡 INDEX Լ ROW Լ ؼ ´. ԷѴ.   

ǰ 

[D18:D32]

=INDEX(ǰ,ROW(A1))

[H18:H32]

=INDEX(,ROW(A1))

ܰ

[J18:J32]

=INDEX(ܰ,ROW(A1))

޴밡

[M18:M32]

=INDEX(ݾ,ROW(A1))

   

[H33] =հݾ Էؼ [հݾ] ״ ǥѴ.

     


3) ڿ ϱ

* Ͽ ٿֱ

ڿ ޹޴ڿ ؾ Ѵ. =ּҡ ̿ϸ ޹޴ڿ ִ ڿ ״ ǥ ִ.

[V6] =E6 Էؼ ޹޴ڿ뿡 ִ ŷó ״ ǥѴ.

̿ؼ ִ. ԷѴ.   

[W8]

=F8

[W10]

=F10

[AD10]

=M10

[W11]

=F11

[W13]

=F13

[AD13]

=M13

   

[B15:M15] ϰ [Ctrl+C] Ѵ.

   

[S15:AD15] ϰ [ٿֱ] ȭǥ [Ͽ ٿֱ] Ѵ. ׷ =B15, =F15, =M15 ԷµǾ ǥѴ.

   

   

, ǰ, ܰ, ޴밡 [Ͽ ٿֱ] Է ִ. [B18:M32] ϰ [Ctrl+C] Ѵ.

[S18] [ٿֱ] ȭǥ [Ͽ ٿֱ] Ѵ.

   

      

[Y33] =H33 Էؼ հ踦 ǥѴ.

   


4) Ǻ 0

* ̵ ɼ ϱ

INDEX Լ INDEX Լ 0 Ÿ. ̷ ǥõ 0 Ǻ ̿ ̴.

[][̵] ޴ ؼ [̵] ȭڸ Ÿ [ɼ] ŬѴ.

[̵ ɼ] ȭڿ [] ɼ ϰ [Ȯ] ŬѴ. ׷ ũƮ ִ ڵ ° ȴ.

   

[][Ǻ ] ޴ ؼ [Ǻ ] ȭڸ Ÿ.

   

[ ], [ ] ϰ 0 Է [] ŬѴ.

   

[ ] ȭ [۲] ǿ [] ϰ [Ȯ] ŬѴ.

[Ǻ ] ȭڿ ٽ [Ȯ] Ŭϸ 0 ۲ Ǿ ȭ鿡 ƹ ͵ ó ̰ ȴ.

   


Ʈ



ۼ ڸƮ ϴ.

Խù ǰ Է ּ(4,000 ̳).
ڵ
 2007
μ ⹮
ǻȰ ⹮
2013 ޿ ڵ
ܿ ⹮ ˻
ڵȭ
ڵȭ
ǹ
ε帲  ˻
ڵȭۿû
ȣ : ε帲ȹ | ڵϹȣ : 105-20-55088 | ǸžŰȣ : 5343ȣ | ǥ : |
å : ̼ҿ | ּ : Ư ŷ16 47 201ȣ() | ȭ: 02)323-7705 |
Fax: 0504)446-5419 | Աݰ : (543001-01-213514) | E-Mail :
Copyright 2006 ε帲ȹ(www.edodream.com) All Rights Reseved.