EXCEL请问怎么改这段函数能让最后结果显示的是百分比(取小数点后两位的百分比)
=IF(B2-A2>0,"提高",IF(B2-A2=0,"保持","下降"))&ROUND(ABS(B2-A2)/MIN(A2:B2),2)
人气:413 ℃ 时间:2019-10-19 22:24:47
解答
建议改成
=TEXT((B2-A2)/MIN(A2:B2),"提高0.00%;下降0.00%;保持")请问,那ROUND和ABS放哪里比较合适?这个公式不需要ROUND和ABS。
推荐
猜你喜欢
- 在三角形ABC中,AB=AC,BD为AC边上的高,则角A与角CBD的关系为?
- it is not ___ you have said but what you have done ___ made us very disappointed
- z的模=1,Z不等于正负i,求证z/(1+z^2)属于R
- The new movie,Xing Xiuniang,which tells the story about the great master of Huangmei OPera,will be put on next year(选出与划
- 两个素数的和是26,这两个素数的乘积最大是多少?最小是多少?
- Thanksgiving Day is a h_____ in the USA.
- 两个电阻R1,R2串联后的总电阻为20欧姆,并联后的总电阻为3.75欧姆.求R1,R2的阻值请用初中物理知识解决
- 我真后悔 作文(400字)