ǰλã > Excel̳ > Excel >

ExcelCԃϵy

  • Excel
  • 2017-10-20
  • 1

ExcelCԃϵy

ώ̴Ė|ǾCԃϵyֻҪݔC̖a͕Ԅ@ʾgФԼڵ؅^ϢDzǷdz^a

ȻҪ@һCԃϵy҂Ҫ֮ǰWһЩȻMϲͿ_҂ҪЧǺ䌍ǰ׹nҪǞ˽o䁉|õĿǞ˽܉̴@һCԃϵyµײώҲṩõCԃϵyodҿdȥWһ

ExcelCԃϵy

ȿώһGIFӮDƬЧ

ExcelCԃϵy

CДԄe

=IF(MOD(MID(A2,17,1),2),"","Ů")

ԔcxCДŮԄe

 

Cȡg

=DATEDIF(--TEXT((LEN(A2)=15)*19&MID(A2,7,6+(LEN(A2)=18)*2),"0-00-00"),TODAY(),"y")&"ܚq"&DATEDIF(--TEXT((LEN(A2)=15)*19&MID(A2,7,6+(LEN(A2)=18)*2),"0-00-00"),TODAY(),"ym")&""&DATEDIF(--TEXT((LEN(A2)=15)*19&MID(A2,7,6+(LEN(A2)=18)*2),"0-00-00"),TODAY(),"md")&"졿

ԔcxCӋgʽ

 

=TEXT(MID(A2,7,8),"00000")

Ԕcx

 

CӋФ

Ф=IF(LEN(A2)=15,MID("Rui",MOD("19"&MID(A2,7,2)-4,12)+1,1),MID("Rui",MOD(MID(A2,7,4)-4,12)+1,1))

=VLOOKUP(VALUE("1900-"&TEXT(MID(A2,LEN(A2)/2+2,4),"#-##")),{1,"Ħ";20,"ˮƿ";50,"p~";81,"";111,"ţ";142,"p";174,"з";205,"{";236,"̎Ů";267,"";298,"Ы";328,"";357,"Ħ"},2,TRUE)

ԔcxCӋɳФ

 

Cȡʡݵ؅^

=VLOOKUP(LEFT(A2,6),Sheet2!A:B,2,1)

ԔcxCȡʡݵ؅^

 

׌#VALUE!e`հ@ʾ

IFERROR

Ԕcxiferrorʹ÷

ֻҪϺͿԼһExcelCԃϵyDzǷdzsoԼֲһ°

ExcelCԃϵyd

ٶ

  • Pע΢Pע΢

ϲg

1l

luՓ

cQ

΢Ź̖

΢Ź̖
994059˹ʲô