当前位置:首页 >> 其它课程 >>

维文函数大全2


?? EXCEL????????????? ?????????? ?? .76????????? ??????? ???????????? ??? ?01/12/2005???????? ?? ?20050112??? ????????? ??????? ?)?=RIGHT(A1,4)&MID(A1,4,2)&LEFT(A1,2?? ?)"?=YEAR(

$A2)&TEXT(MONTH($A2),"00")&TEXT(DAY($A2),"00?? ??? ?2005 年 9 月???????? ?? ?200509??? ????????? ??????? ?????? ????? ? =text(a1,"yyyymm")+0?????????? ????????? ???????? ????????? ?? ?常规??????? ??????.?? ??? ?2005-8-6???????? ?? ?20050806??? ????????? ??????? ?)"?=TEXT(A1,"YYYYMMDD?? ??? ?20050806???????? ?? ?2005-8-6??? ????????? ??????? ?))?=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2?? ????? ????? ??? ??? ????? ????:?? ??=text(a1,"0000-00-00") 显示:?? ?)"?=--TEXT(A1,"#-00-00?? ??2005-08-06?? ??显示:2005-8-6??

??=TEXT(20050806,"0000-00-00")*1 显示:2005-8-6?? ??显示:2005-8-6?? ?))?=VALUE(LEFT(A1,4)&"-"&MID(A1,5,2)&"-"&RIGHT(A1,2??

??? ?20050806???????? ?? ?2005-08-06??? ????????? ??????? ?))?=DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2?? ??? ?200508???????? ?? ?2005-8??? ????????? ??????:?? ??=LEFT(A3,4)&"-"&RIGHT(A3,2)*1??
?)"?=--TEXT(A3*100+1,"#-00-00??

?? e-m?????? ???????? ??????

?)"?=TEXT(TEXT(A3&"01","0000-00-00"),"e-m??

???????????? ??? ? ???????726996931 :??

??????????? :???????? ?????? ???? ???? ????????? ??????????

?? - 1?????

? ???????????? ??????????EXCEL ? ? ?? ??????????2005.08? ? ? ????????200508?

.76
=mid(xxxxxx,1,4) & "." & right(xxxxxx,2) 单元格格式/数字/自定义,类型下面输入:####"."##

:?? ?? ????????? ??????2004-1-2? ?? ????????2004.01.02? =DATE(MID(A1,1,4),MID(A1,6,2),MID(A1,9,2)) :?? ?? ????????? ??????2005 年 8 月 6 日? ?? ????????2005-8-6? =TEXT(A1,"yyyy""年""m""月""d""日"";@") ? ??( ??????? ???????? ?????? ????????????22 :? ????? ??? ????? )????????.76 =date(year(now()),month(now()),22) ? ? ?? ????????????2006

年 05 月?

? ? ????????2006

年 5 月? .67
=TEXT(A8,"yyyy""年""mm""月"";@")

设置单元格公式-数字-自定义,将 yyyy“年”m“月”改为:yyyy“年”mm“月” ? ? ?? ??????????1968/6/12? ? ? ????????1968

年 6 月 12 日? .67

显示:1968/6/12 =YEAR(A1)&"/"&MONTH(A1)&"/"&DAY(A1) 显示:1968/06/12

=TEXT(A1,"yyyy/mm/dd")

? ? ?? ??????????1968-6-12? ? ? ????????1968

年 6 月 12 日? .62
=YEAR(A1)&"-"&MONTH(A1)&"-"&DAY(A1) 显示:1968-6-12

=TEXT(A1,"yyyy-mm-dd") 显示:1968-06-12

? ? ?? ??????????1993

年 12 月?

? ? ????????1993-12-28?

.67

=CONCATENATE(YEAR(A1),"年",MONTH(A1),"月")

?"?=YEAR(A1)&"年"&MONTH(A1)&"月??

???????????? ??? ? ???????726996931 :??

??????????? :???????? ?????? ???? ???? ????????? ??????????

?? - 2?????

?? EXCEL????????????? ?????????? ?"?也可以自定义格式 [$-404]e"年"m"月?? ??? ? 1978-5-2???????? ?? ? 197805??? ??????????

??.67??
?)"?=year(A1)&text(month(A1),"00??

?? .67???? ???????? ?????????? ???????? ?)?=IF(B2="","",ROW(B2)-1?? ?????????? ?????????? ??????????? ??? ???????? ????????????.?? ?? .67????????? ??????
?)?=RANK(A1,$A$1:$A$5??

???????? ????? ? B2?????? ?????? ?????? ?????????? ??????? ????? ???????

?)?=RANK(A1,A:A??

?? .66??????????? ?????? ?????????? ?????? ????? ?????? ))?SMALL(A:A,ROW(1:1?? ?))?LARGE(A:A,ROW(1:1?? ???????? ?????? ????? ???????

?? .66?????? ??????????? ????????? ?????? ???? ??????????? ??????????? ?)?=EXACT(B53,C53?? ?? .66???????? ?????? ????? ? 72???????? ??????? ?????????? ?????? ?????? ?”?设置数据有效性:自定义>公式:“=LEN(A7)=72?? ?? .67?????? ??????? ??? ????????? ???????????? ?? -7???? ??????
??=IF(TRUNC(H16)=H16,TEXT(H16,"[DBNum2]G/通用格式")&"元整",TEXT(TRUNC(H16),"[DBNum2]G/通?? ?*?用格式"&"元"))&IF(AND(TRUNC(H16)<>H16,RIGHT(TRUNC(H16*10))<>"0"),TEXT(TRUNC(MOD(H16??

???????????? ??? ? ???????726996931 :??

??????????? :???????? ?????? ???? ???? ????????? ??????????

?? - 3?????

? ???????????? ??????????EXCEL
10,10)),"[DBNum2]G/通用格式")&"角","")&IF(AND(RIGHT(TRUNC(H16*10))="0",TRUNC(H16)<>H16),"

零","")&IF(TRUNC(H16*10)<>H16,TRUNC(H16*10)=H16*10), "整","") ? ??? ??????-2
=IF(F10=0,"",CONCATENATE(IF(INT(F10)=0,"",TEXT(INT(F10),"[DBNum2]G/ 通用格式元")),IF(INT(MID(R IGHT(FIXED(F10,2,1),2),1,1))=0,IF(INT(MID(RIGHT(FIXED(F10,2,1),1),1,1))=0,"",IF(INT(F10)=0,""," 零")),T EXT(INT(MID(RIGHT(FIXED(F10,2,1),2),1,1)),"[DBNum2]G/通用格式角")),IF(INT(MID(RIGHT(FIXED(F10,2,

1),1),1,1))=0,"整",TEXT(INT(MID(RIGHT(FIXED(F10,2,1),1),1,1)),"[DBNum2]G/ 通用格式分")))) ? ??? ??????-7
=IF(A1<0,"负","")&IF(TRUNC(A1)=A1,TEXT(IF(A1<0,-A1,A1),"[DBNum2]")&"元整",IF(TRUNC(A1*10)=A1*10,TEXT(TRUNC(IF(A1<0,-

A1,A1)),"[DBNum2]")&"元"&TEXT(RIGHT(A1),"[DBNum2]")&"角整",TEXT(TRUNC(A1),"[DBNum2]")&"元"&IF(ISNUMBER(FIND(".0",A1)),"零

",TEXT(LEFT(RIGHT(A1,2)),"[DBNum2]")&"角")&TEXT(RIGHT(A1),"

[DBNum2]")&"分")) ? ??? ??????-7
=IF(A1<0,"负","")&IF(TRUNC(A1)=A1,TEXT(IF(A1<0,-A1,A1),"[DBNum2]")&"元整

",IF(TRUNC(A1*10)=A1*10,TEXT(TRUNC(IF(A1<0,-A1,A1)),"[DBNum2]")&"元

"&TEXT(RIGHT(A1),"[DBNum2]")&"角整",TEXT(TRUNC(IF(A1<0,-A1,A1)),"[DBNum2]")&"元

"&IF(ISNUMBER(FIND(".0",A1)),"零",TEXT(LEFT(RIGHT(A1,2)),"[DBNum2]")&

"角")&TEXT(RIGHT(A1),"[DBNum2]")&"分")) ? ??? ??????-7

???????????? ??? ? ???????726996931 :??

??????????? :???????? ?????? ???? ???? ????????? ??????????

?? - 4?????

? ???????????? ??????????EXCEL
=IF(A1<0,"负",)&TEXT(TRUNC(ABS(A1)),"[DBNum2]G/通用格式")&"元 "&IF(ROUND(A1,3)=ROUND(A1 ,),"整

",TEXT(RIGHT(TRUNC(A1*10),1),"[DBNum2]G/通用格式")&"角"&IF(ROUND(A1,3)=ROUND(A1,1),"整

",TEXT(RIGHT(ROUND((A1*100),),1),"[DBNum2]G/通用格式")&"分"))

? ??? ??????-7
=CONCATENATE(IF(A1<0,"负",""),TEXT(IF(TRUNC(A1)=0,"零",TRUNC(ABS(A1))),"[DBNum2]")&"元",IF( OR(AND(ABS(A1)<0.1,TRUNC(A1)=A1),RIGHT(INT(ABS(A1)*100),2)="00"),"",TEXT(RIGHT(TRUNC(A1*

10),1),"[DBNum2]")),IF(RIGHT(TRUNC(A1*10),1)="0",""," 角"),IF(OR(TRUNC(A1*10)(A1*10)=0,RIGHT(TRUNC(A1*100),1)="0"),"整",TEXT(RIGHT(TRUNC(A1*100),1),"[DBNum2]")&"分")) :? ???? ??????? ???????? ???????? ?????????2 ??????? ????? ??????????
=CONCATENATE(IF(A1<0," 负 ",""),TEXT(IF(TRUNC(ROUND(A1,2))=0," 零 ",TRUNC(ABS(ROUND(A1,2)))), "[DBNum2]")&" 元

",IF(TRUNC(ROUND(A1,2))=ROUND(A1,2),"",TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)

,1),"[DBNum2]")),IF(RIGHT(TRUNC(ROUND(A1,2)*10),1)="0","","



"),IF(OR(TRUNC(ROUND(A1,2)*10)-

(ROUND(A1,2)*10)=0,RIGHT(ROUND(A1,2),1)="0",TRUNC(ROUND(A1,2))=ROUND(A1,2)),"整",TEXT(R

IGHT(ROUND(A1,2),1),"[DBNum2]")&"分")) ? ??? ??????-6
=IF(A1<0,"负","")&SUBSTITUTE(TEXT(TRUNC(A1),"[DBNum2]")&"元"&IF(ISNUMBER(FIND(".",TRUNC( A1,2))),TEXT(RIGHT(TRUNC(A1*10)),"[DBNum2]")&IF(ISNUMBER(FIND(".0",A1)),"","角"),"")&IF(LEFT(RI

GHT(TRUNC(A1,2),3),1)=".",TEXT(RIGHT(TRUNC(A1,2)),"[DBNum2]")&" 分","整"),"-",) :? ???? ??????? ???????? ???????? ?????????2 ??????? ????? ??????????
=IF(A1<0,"负","")&SUBSTITUTE(TEXT(TRUNC(ROUND(A1,2)),"[DBNum2]")&"元"&IF(ISNUMBER(FIND(

??".",ROUND(A1,2))),TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),"[DBNum2]")&IF(ISNUMBER(FIND(".0",RO??

???????????? ??? ? ???????726996931 :??

??????????? :???????? ?????? ???? ???? ????????? ??????????

?? - 5?????


相关文章:
人教版七年级语文上册第24课_2
人教版七年级语文上册第24课_2_语文_初中教育_教育专区。人教版七年级语文上册...三、课时安排 一课时 四、教学过程 (一)导入新课 播放歌曲(PPT 课件)阎维文...
人教版七年级语文上册第24课_2
人教版七年级语文上册第24课_2。人教版七年级语文上册第 24 课 《荷叶 母亲...三、课时安排 一课时 四、教学过程 (一)导入新课 播放歌曲(PPT 课件)阎维文...
2015反假题库2
2015反假题库2_从业资格考试_资格考试/认证_教育...蒙文和维文,其中汉字“中国人民银行”字样由 毛泽东...本部门假币收缴情况进行汇总分析 45、《中国人民银行...
大学计算机网络第二章
2、 试解释以下名词:数据,信号,模拟数据,模拟信号,基带信号,带通信号,数字数据...还 有韩文的 28 进制字母码元键盘,俄文的 33 进制字母码元键盘,以及中国维文的...
2016教师信息化应用培训模拟题(第4套)
使用单元格地址$D$2 引用 D 列 2 行单元 格,...通过点击课文页面下方的(维文翻译)按钮进行翻译 D....直接在单元格中输入函数 B.直接在编辑栏中输入函数...
学校德育工作档案B18网络育人非维文版(2013-2014)3月
B18 网络育人 2013--2014 学年 2013--2014 学年 卷内文件目录序 号 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 档案内容...
知识产权法二套
知识产权法套_司法考试_资格考试/认证_教育专区。知识产权法套 一、单选题...乙将该杂 文译成法文,丙将之译成维文,均在国内出版,未征得甲的同意,也未...
八年级汉语第二课甘甜的不只是井水
课《甘甜的不只是井水》 (一)教学目标 1.本课的 16 个词语。要求会读...今天大家去游玩,心情特别畅快 我们如果学好汉语,总有一天也会象维文一样说起来...
1907年喀什大清银币湘平壹两银币一枚 2
进入民国后,继续铸造饷银,仅五钱一种,背图双旗及维文。阿克苏局所铸光绪银元, 自二钱至五钱计 3 等。至民国三十八年(1949 年),新疆始废“两”改“元”,...
高一政治政治权利与义务2
识记:(1)我国公民法定的政治权利和自由的内容;(2)我国公民法定政治性义务的 ...著名歌唱家阎维文在《说句心里活》这首歌中唱的“你 不扛枪,我不扛枪,谁...
更多相关标签: