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

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


赞助商链接
相关文章:
毛概整理版2
陈国昌 、目录: 1、平遥的经济发展 2、平遥的...在 2014 年 5 月由平遥籍歌唱家闫维文担当主演、...《毛概》复习资料大全(4... 48页 5下载券 毛概...
小学语文:孝敬父母 教学设计(北京版二年级下册)
小学语文:孝敬父母 教学设计(北京版年级下册)_其它课程_小学教育_教育专区。...要孝敬父 教学重点:怎么样孝敬父母 教学过程:一、 听阎维文的歌曲《母亲》创设...
语文版七上第二单元教案
2、儿不嫌母丑,狗不嫌家贫。 3、儿行千里母担忧 4、阎维文《母亲》 :你入学的新书包有人给你拿,你雨中的花折伞有人给你打, 你爱吃的(那)三鲜馅有人给...
2013初中物理试题二
10.2013 年 2 月 13 日, 央视国际频道直播了 “文化中国· 四 海同春”大型新春歌舞晚会,阎维文的一首《想家的时候》 牵动无数华人的心,现场响起雷鸣般的...
《慈母情深》教案二小冀箭
课时安排:1-2 课时。 课前准备:多媒体课件、阎维文《母亲》 教学过程: 一、激趣引入,感悟解题。 有一首歌曲里这样写道: 你入学的新书包有人给你拿,你雨中的...
新初级汉语(2)平时作业(一)
(除了?..以外) 2、___,爸爸妈妈什么活儿都不让他干。 (为了) 3、看到他...B、对不起,有没有维文的,中文的我___。 A、没有维文的表格。 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. 聆听歌曲范唱, 感受妈妈的辛苦与...结尾如老师在拓展唱一首阎维文 的《母亲》让学生比较就更好了,亦可以拓宽学生...
第二届中国环保公益广告大赛作品征集
届中国环保公益广告大赛及系列活动是 2005 中国环境文化节的重要组成 部分。...张信哲、伍思凯、郁钧剑、阎维文、腾格尔等一批明星参加了文化节各项演出,吸引了大...
基坑支护专项方案(改改改改改改改张乾) 2_图文
基坑支护专项方案(改改改改改改改张乾) 2_建筑/...胡维文 黄秋莹 设备材料部 何文雄 陈锦锋 预算财务...拟投入的材料汇总表进场材料名称 材料规格 数量 ...
更多相关标签: