EXCEL怎么把两个不同的公式合并成一个公式?
来源:学生作业帮 编辑:百度作业网作业帮 分类:综合作业 时间:2024/08/19 15:19:22
EXCEL怎么把两个不同的公式合并成一个公式?
="日期:"&TEXT(TODAY(),"yyyy-m-d")&"【"&TEXT(TODAY(),"[$-804]aaaa;@")&"】"
=""&TEXT(MOD(NOW(),1),"[H]时M分S秒")
="日期:"&TEXT(TODAY(),"yyyy-m-d")&"【"&TEXT(TODAY(),"[$-804]aaaa;@")&"】"
=""&TEXT(MOD(NOW(),1),"[H]时M分S秒")
![EXCEL怎么把两个不同的公式合并成一个公式?](/uploads/image/z/15810077-29-7.jpg?t=EXCEL%E6%80%8E%E4%B9%88%E6%8A%8A%E4%B8%A4%E4%B8%AA%E4%B8%8D%E5%90%8C%E7%9A%84%E5%85%AC%E5%BC%8F%E5%90%88%E5%B9%B6%E6%88%90%E4%B8%80%E4%B8%AA%E5%85%AC%E5%BC%8F%3F)
="日期:"&TEXT(TODAY(),"yyyy-m-d")&"【"&TEXT(TODAY(),"[$-804]aaaa;@")&"】"&""&TEXT(MOD(NOW(),1),"[H]时M分S秒")
其实你可以只用一次now()啊
="日期:"&TEXT(NOW(),"yyyy-m-d【aaaa】h时m分s秒")
其实你可以只用一次now()啊
="日期:"&TEXT(NOW(),"yyyy-m-d【aaaa】h时m分s秒")