Persian Function for Microsoft EXCEL_V2
description
Transcript of Persian Function for Microsoft EXCEL_V2
-
ri.narasraf.www
7002/22/8
-
2
stnetnoC fo elbaT
3 .............................................................................................................................................................................. :2
4 ........................................................................................................................................................................................... :
5 .......................................................................................... )2 (
6 ....................................................................................................................................................... nI-dda
6 ......................................................................................................................................................................
6 ...................................................................................................................................................................... 7002
7 ................................................................................................................................................................... 3002
8 .......................................................................................................................................................................................
9 ........................................................................................................................................................................................ HBA
01........................................................................................................................................................................... YADOT_J
11.................................................................................................................................................................... YADKEEW_J
11........................................................................................................................................................................ YADDDA_J
21................................................................................................................................................................................. FFID_J
21.................................................................................................................................................................. ETADLALAJ_J
31.................................................................................................................................................... ETADNAIROGERG_J
31........................................................................................................................................................................ YADBUS_J
41................................................................................................................................................................. ETADMRON_J
51...................................................................................................................................................................................... HBT
61............................................................................................................................................................................... PAEL_J
61.................................................................................................................................................................. RAEYFOYADJ
71................................................................................................................................................................... SRAEYPAELJ
71..................................................................................................................................................................... SYADILALAJ
81................................................................................................................................................................ RAEYFOYADG
81.......................................................................................................................................................................... RTS2DMY
91................................................................................................................................................................................. ETADF
91................................................................................................................................................................................ PAELG
02................................................................................................................................................................ NEYCNERRUC
02........................................................................................................................................................................
12..........................................................................................................................................................
-
3
:2 .
5831/5/1
04 .
.
.
. "
" .
2 .
.
.
ri.narasraf.www: . :
/ 6831 1/
-
4
: teehsdaerpS
. . ) (
! (.
).
- LQS
BV .
. LLD nI-dda
.
.
5831/5/1
.
-
5
)2 (
nI-ddA . 01 LLD
nI-ddA . )nI-dliuB (
( ) ( ABV : )
. etsaP-ypoC .1 . ) ( .2
.
( . )snI-ddA
: . nI-ddA .1 . ) ( nI-ddA .2 . .3
7002 3002 .
-
6
nI-dda
(. alx.lecxE rof noitcnuF naisreP
). ri.narasraf.www ! :
7002 : : 1
. snoitpO lecxE : 2
. snI-ddA : 3
. oG : 4
. alx.lecxE rof noitcnuF naisreP esworB : 5
-
7
3002
. slooT : 1
. snI-ddA : 2
. alx.lecxE rof noitcnuF naisreP esworB : 3
snI-ddA : . lecxE rof noitcnuF naisreP xoB kcehC
-
8
:
. denifeD resU noitcnuf tresnI
.
: :
10/20/58 1/2/58 1/2/5831 10/20/5831
. )nolocimeS( ; )noloC( , : emotsuC snoitpO egaugnaL & lanoigeR lenaP lortnoC
. rotarpeS tsiL rebmuN )BAT( .
-
9
HBA .
: xatnyS )rebmun(HBA
: rebmun . . . 5
. 999/999/999/99999.999 : :
THGIR TFEL .
. 1A 222,111,987,654,321 . &
:
""_ . )ECAPS( :
B A
)1A(HbA= 321 1
)2A(HbA= 1.21- 2
)3A(HbA= 54321.0 3
)4A(HbA= 21.0- 4
)5A(HbA= 999999 5
B A
" " & )1A(HbA= 001 1
" " & )1A(HbA= 0001 2
" " & )1A(HbA= 000001 3
" ****** " & )1A(HbA= ****** 0000001 4
" " & )1A(HbA= 0000001 5
-
01
YADOT_J .
:xatnyS )EDOM(YADOT_J
. 1 : edoM :
10/50/58 )(YADOT_J=
10/50/5831 )1(YADOT_J=
teehS )(YADOT )(WON
. .
. teehS
. 9F teehS .1 . retnE .2 . .3
. ; + lrtC
. q + lrtC .
-
11
YADKEEW_J .
:xatnyS ) EDOM,ETADJ(YADKEEW_J
. " " : ETADJ :
3 )"1/1/5831"(YADKEEW_J=
)1,"1/1/5831"(YADKEEW_J=
)1,)(YADOT_J(YADKEEW_J=
YADDDA_J .
:xatnyS ) EDOM,REBMUN,ETADJ(YADDDA_J
. " " : ETADJ . : REBMUN
! . 1 : edoM
:
12/10/5831 )1,02,"1/1/58"(YADDDA_J= 12/10/58 )02,"1/1/58"(YADDDA_J=
12/50/5831 )1,02,)(YADOT_J(YADDDA_J=
-
21
FFID_J .
:xatnyS )2ETADJ,1ETADJ(FFID_J
. " " : 1ETADJ . " " : 2ETADJ
:
9- )"1/10/5831","01/10/5831"(ffid_J=
9 )"01/10/5831","1/10/5831"(ffid_J=
ETADLALAJ_J .
:xatnyS )edoM,ETADM( ETADLALAJ_J
. // : ETADM :
10/10/58 )"12/3/6002"(etadlalaj_J=
.
: . TXET
. )(yadot_J
))"DD/MM/YYYY",)(YADOT(TXET(ETADLALAJ_J=
. YADOT : ) 0091 (
TXET . ETADALAJ_J
-
31
ETADNAIROGERG_J .
:xatnyS )EDOM ,ETADM( etaDnairogerG_J
. : ETADM . 4 : EDOM
B A )1,1A(etaDnairogerG_J= 80/80/8791 71/5/7531 1
)1A(etaDnairogerG_J= 80/80/87 71/5/7531 2
)"71/5/7531"(etaDnairogerG_J= 80/80/87 3
4
5
YADBUS_J .
:xatnyS )EDOM,REBMUN,ETADJ(YADBUS_J
. " " : ETADJ . : REBMUN
. 1 : edoM . ETADDDA_J :
10/10/48 )563,"1/1/58"(YADBUS_J=
10/10/4831 )1,563,"1/1/58"(YADBUS_J=
-
41
ETADMRON_J .
:xatnyS )ETADJ(ETADMRON_J
" " : ETADJ
71505831 )"71/5/5831"(ETADMRON_J=
71505831 )"71/5/5831"(ETADMRON_J=
715058 )"71/5/58"(ETADMRON_J=
.
:
B A
)1A(ETADMRON_J= 50/50/58 1
)2A(ETADMRON_J= 01/50/58 2
)3A(ETADMRON_J= 7/50/58 3
))1B>3B,2B
-
51
HBT .
:xatnyS )EDOM,ETADJ(HBT
. " " : ETADJ . : EDOM
tamroF . noitceriD txeT . tnemgilA slleC
. 1 . 2
B A
)1A(hbt= 7531 41 41/5/7531 1 )1,2A(hbt= 51/5/7531 2
61/5/7531 3
)2,3A(hbt=
4 5
. foroH b xiraT
-
61
PAEL_J .
:xatnyS )ETADJ(pael_J
. : ETADJ . 1
B A
)1A(paelj= 0 1831 1
)2A(paelj= 0 2831 2
)3A(paelj= 1 3831 3
)4A(paelj= 0 4831 4
5
RAEYFOYADJ .
:xatnyS )DD,MM,YYYY(raeYfOyaDJ=
: YYYY : MM : DD
B A
)1,1,6831(raeYfOyaDJ= 1 1
)92,21,6831(raeYfOyaDJ= 563 2
3
4
5
-
17
JLEAPYEARS
=JLeapYears(YYYY) YYYY : .
A B
1 1 =JLeapYears(1)
2 329 =JLeapYears(1357)
3 336 =JLeapYears(1386)
4
5
JALALIDAYS (1/1/1) ! .
Syntax =JalaliDays(YYYY,MM,DD)
YYYY : MM : DD :
A B
1 1 =JalaliDays(1,1,1)
2 495410 =JalaliDays(1357,5,17)
3 506017 =JalaliDays(1386,6,1)
4
5
-
81
RAEYFOYADG
. xatnyS )DD,MM,YYYY(RAEYFOYADG=
: YYYY : MM : DD
B A
)1,1,7002(raeYfOyaDG= 1 1
)13,21,7002(raeYfOyaDG= 563 2
3
4
5
RTS2DMY .
xatnyS )EDOM,DD,MM,YYYY(RTS2DMY=
: YYYY : MM : DD
. gnoL : edoM
B A
)3A,2A,1A(rtS2DMY= 715068 6831 1
)"gnol",3A,2A,1A(rtS2DMY= 71506831 5 2
71 3
4
5
-
91
ETADF . DD/MM/YYYY
xatnyS )ETAD(ETADF=
"/" DDMMYY DDMMYYYY : ETAD
.
B A
)1A(etaDF= 71/50/68 715068 1
)2A(etaDF= 71/50/6831 71506831 2
3
4
5
PAELG .
:xatnyS )ETADG(paelG
. 1 . : ETADG
B A )1A(paelG= 1 4002 1
)2A(paelG= 0 5002 2
)3A(paelG= 0 6002 3
)4A(paelG= 0 7002 4
5
-
02
NEYCNERRUC .
xatnyS )rebmuN(nEycnerruC=
. : rebmuN
B A
321 1 oN dnA sralloD eerhT ytnewT derdnuH enO
stneC )1A(nEycnerruC=
987.654 2 ytneveS dnA sralloD xiS ytfiF derdnuH ruoF
stneC thgiE )2A(nEycnerruC=
)3A(nEycnerruC= stneC ruoF ytroF dnA sralloD oN 544.0 3
)4A(nEycnerruC= stneC oN dnA sralloD oN 0 4
5
.
EMAN#
. . nI-ddA
.
eulaV# .
. moc.dirgzo
-
12
. :
).. ( )gnidocne(
ABV . 8-FTU ) ( . lacoL metsyS )edocinU non(
: PX )xob obmoc( israF )bat( decnavdA snoitpO egaugnaL & lanoigeR lenaP lortnoC
: atsiV
metsyS egnahC )bat( evitartsinimdA snoitpO egaugnaL & lanoigeR lenaP lortnoC naisreP lacoL
. tratseR