excel怎么把="需完成"&250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY())算出来的数字小数点后面的数字去掉
答案:3 悬赏:60 手机版
解决时间 2021-11-17 12:28
- 提问者网友：棒棒糖
- 2021-11-16 20:08
excel怎么把="需完成"&250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY())算出来的数字小数点后面的数字去掉
最佳答案
- 五星知识达人网友：罪歌
- 2021-11-16 20:26
看下面哪个公式满足你的要求：
="需完成"&INT(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()))
="需完成"&ROUND(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()),0)
="需完成"&CEILING(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()),1)
="需完成"&FLOOR(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()),1)
="需完成"&TRUNC(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()))
="需完成"&INT(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()))
="需完成"&ROUND(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()),0)
="需完成"&CEILING(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()),1)
="需完成"&FLOOR(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()),1)
="需完成"&TRUNC(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()))
全部回答
- 1楼网友：洎扰庸人
- 2021-11-16 22:23
="需完成"&round(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()),)
- 2楼网友：骨子里都是戏
- 2021-11-16 21:40
="需完成"&INT(250000/DAY(EOMONTH(TODAY(),0))*DAY(TODAY()))
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯