CÁC HÀM TRONG EXCEL
Posted on 29, Tháng Một , 2008 by Cao Lãng
!"# $%&
'(!)*+#!), /0&1 !2!*3&4&!)*+#!),5607&1 (8!9
&# 3&4
: ;
<*!),=(*&9!(1 4"!),
<1 !(1 !),!>?!= )@&!A&B&!),4,CD
<1 +E&!(1 $F&"!),!A(!)*+#@GH/0I
HJKL
MNO7NPQ777
R.
!"# $%&
'(!)*+#!), /0&1 2!"(8!&3&4&!)*+#!),5607&1 !2!*
3&4
HJKL
MR.5NO7ST7TNU5NO7T7T77
R-
V(8!!),9(8! !"
'(*&:W!),36XKL&R-$Y&( &3,&!),3!)&Z
!
(!)g&(8!
.R//_ (>) (K!
!(
< (>)(8!!b(Y&( &(!)g&h&
< (>)K!i!ic&(Y&( &(!)g&
;
<1 (K!O7j(!)g&k&!ic&
<1 (K!M7j(!)g&h&!b&h&k&&2!
<1 (K!P7j(!)g&k&& 9h& K2 !ic&
"#
(!)g&h&!&& 9h&l&k&&2!
0H0 (>)
!( (>)(Y&( &(!)g&
;
<1 (>)$F&*$ !A(!)*+#@GH/0I
$
(!)g&h&!&& 9h&mk&&2!
R (>)
-( (>)(Y&( &(!)g&
%
(!)g&? &(8!
.R/R` (>) (K!
!(!:n&!b&:(.R//_
&'(
)*)+,-)+ /
-)*+#x&&2!!)&Ke9:W&i
f{ (>) (>)
!( (>) (>)Ke9(Y&( &!A(!),x&&2!r!)&4HJKL
-A(x&!"$!)&(8!Ke9:W&i
.z0))9$
!(
<))9(8!(*&=(8!+E&KB%
<$!"Y&3Y&( &!A($!^x&&2!!)&Ke9
HJKL
-)*+#&C&2!!)&Ke9:W&i+
ft (>) (>)
!( (>) (>)Ke9(Y&( &!A(!),&C&2!r!)&4
-A(&C!"$!)&(8!Ke9:W&i+
6f))9$
!(
<))9(8!(*&=(8!+E&3KB%
<$!"Y&3(Y&( &!A($!^&C&2!!)&Ke9
)*)=>?@81A5
'(R/-1(F"KB% $ !)&Ke9
R/-H >H >
!(H >H >(*&9Ke9KB%
-)J$;!b!^~!k !)& @:W&i+
ft->?!6!)!& ( ()
<->?! @+|&*&
<6!)!& (6!"!b3$;!b~!k :W!)J
< ()6$;!bk&!)J
Vp @&i+!&B
/__0.->?!
!
Vp @&i+!&B!:•&
R`0.->?!
"
Vp$;!^k 3!^!)& @!&B
_.R_0.->?!
HJKL
M_.R_0.&+&M}_&H&v
$
~!C$;!b!)~&rk @+ @
tf->?!
# B
'(!>!)*+#(8! @!)A&9(8!$ &9=!E
-09>)(&!K9
!(
<€>)(h !*&|(4!!^1&UB1 Y&&iB!>(=,&0?>j29&|(
~!k •77HJKL
<f&!(h !*!&!)&&|(1 (&!x&n&!A0?>j!b8&!J&!h(!&
"'B
-)*+#q!"!)&! k&
`00‚€6>).>! )&!9>
<6>)(8!9!),$ &9
<.>! )&!9>q,&$ KB% !)*+#
# #CD
-)*+#(8! @!)A&9(8!$ !•&=!Ez!),!)*+#(8!!)&$*&!^71&
7••••••••(h !*!•&!^777771&SQ•Q•
-tf0' )f& !>6>&K
!(V:W!J&!:n&!br(-0
<' )(h !*•(8!!^71&SNƒN
<f& !>(h !*!(8!!^71&SNƒN
<6>&K(h !*c9(8!!^71&SNƒN
-)*+#•!)&&93KB% $ •:+z!),!)*+#(8!$ t&!>>)!)&$*&!^7
77f1&S77_f
'R/.6>)& (
-(
6>)& (KB% $ -(>-•&4!:W&i&:
<f8! @$J!b&y(!)&K2 &9+JKL}QS7_fv
<f8!!ic&+JKL7UQ(F!*Q7uf
<‚1!D *3(8!F&!"9(8!($
-)*+#!3KB% $ -(>:+z!),!)*+#(8!$ t&!>>)!)&$*&!^71&Q•
ft/-06>)& (
-(
MHRR‚/_5††7††7
-A((8!!),y&!),rF5!)&8!!"&2!+29!),!:n&"&r8!!"
'
-A($1(!:n&!b&:(HRR‚/_&:&y&&&4+x!),!)&&k
!h&3*&&i+
'RR‚/_$ H >->))9K?& („)&>$ …
!(!:n&!b&:(HRR‚/_
-)*+#(8!!),9(8!!(1 1&(8!!),!)&Y(+*&9+E&KB%
t0{))9.a& (& (
!(
<))9(8!+E&"F=(8!(*&2!1&
1 ))9q"(8!&+(8!8!!(.a& (=& (!:n&"&!E9;
1 ))94&# n&(8!&=(8!8!!Aq(8!.a& (=& (:WXKL&
<.a& (o&b&!)&))91 .a& (:WCD !A& (~! 8
<& (o&b8!!)&))91 & (:WCD !A.a& (~! 8
IJ8I-/