首页 > 代码库 > Excel Skill
Excel Skill
=IF(O2="MIN",ROUND(M2/60,3),IF(O2="S",ROUND(M2/3600,2),M2))
=IF(H2="MIN",ROUND(F2/60,3),IF(H2="S",ROUND(F2/3600,2),F2))
=IF(P2="MIN",RRUND(N2/60,3),IF(P2="H",N2,""))
>>>>>>>>>>>>>>>>>>>>>Determine the std and non-std parts <<<<<<<<<<<<<<<<<<<<<<<<<<
‘= IF(OR(LEFT(C2,3)={"HY6";"HY5";"HY7";"HY8"}),LEFT(C2,3),IF(RIGHT(C2,1)="R",RIGHT(C2,1),RIGHT(C2,2)))
=VLOOKUP( IF(OR(LEFT(C2,3)={"HY6";"HY5";"HY7";"HY8"}),LEFT(C2,3),IF(RIGHT(C2,1)="R",RIGHT(C2,1),RIGHT(C2,2))),A:B,2,0)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
ER Custom
FR Custom
ED Custom
FD Custom
R1 Custom
R Custom
HY5 Custom
HY6 Custom
HY7 Custom
HY8 Custom
SP Custom
Excel Skill
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。