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

维文函数大全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?????


相关文章:
输入维文(第二周)
输入维文(第二周)_计算机硬件及网络_IT/计算机_专业资料。计算机认识 叶城县棋盘中学信息技术教师吐迪阿吉 课题:输入维文字母(1)授课时间:2016 年 8 月 29 日至...
输入维文(第二周)
输入维文(第二周)_法律资料_人文社科_专业资料。课题:输入维文字母(1)(第一课时) 授课时间:第二周 教学目标: 1. 使学生掌握维文字母在键盘上的位置。 2. 解...
维文 信息技术
维文 信息技术_其它课程_小学教育_教育专区。莎车县城南双语实验高中 2013-2014 ...(1)这个表格有几行( (2)写总分的地址( 4.求总分的函数( ) )) 几列( ...
维语部理科考试分析
()、维语部理科 1、试卷结构及难易程度 理科试卷共由选择题、填空题、作图...(1) 从本次期考来看,部分学生不会确定对数函数的定义域, 不熟悉导数的运算...
高等代数二
高等代数_理学_高等教育_教育专区。gaodengshuer练习题一、单选题(2 分/题,...A.汉文 B.蒙文 C.维文 D.满文 正确答案:A、B、C 第 34 题: 第五套...
2015反假题库2
2015反假题库2_从业资格考试_资格考试/认证_教育专区。一、单选题(单选题) ...蒙文和维文,其中汉字“中国人民银行”字样由 毛泽东同志题写 C、我国第一套...
初中数学 2014七年级数学试题维文 (1)
初中数学 2014七年级数学试题维文 (1)_数学_初中教育_教育专区。10 ? 1 7 A.装 3 5 2 4 B. D. 4 6 3 5 2014 2013 7 100 100 1 2 10 C. 5 ...
信息技术技术模拟试卷维文-imtahan suali kompiyoter uyghurqa(新疆高一学业水平考试)2
信息技术技术模拟试卷维文-imtahan suali kompiyoter uyghurqa(新疆高一学业水平考试)2_其它课程_高中教育_教育专区。mtahan suali kompiyoter uyghurqa(新疆高一学业...
冶金原理 2完整版
冶金原理 2完整版_化学_自然科学_专业资料。请观看...制作人员:沈维文,尤嘉意,曹静,白羽佳,林予舒,杨...笑话大全爆笑版 幽默笑话大全 全球冷笑话精选文档...
知识产权法二套
知识产权法套_司法考试_资格考试/认证_教育专区。知识产权法套 一、单选题...乙将该杂 文译成法文,丙将之译成维文,均在国内出版,未征得甲的同意,也未...
更多相关标签:
阎维文歌曲大全 | 阎维文歌曲大全视频 | 阎维文的歌曲大全视频 | 阎维文的歌曲大全 | 阎维文歌曲大全100首 | 维文字体大全 | 阎维文简谱大全 | 阎维文歌曲大全播放 |