EXCEL 問題...求公式?

2014-12-21 12:16 am
EXCEL 問題...求公式?

............1月.............2月..............升幅.............公式
香蕉......6.................8.................25%............=SUM(8-6)/8
蘋果......3.................6.................50%............=SUM(6-3)/6

我想顯示 25%-50% 的公式.......25%-50% =??

回答 (1)

2014-12-22 6:34 pm
✔ 最佳答案
To display 25%:
=TEXT((8-6)/8,"#0%")
To display 50%:
=TEXT((6-3)/6,"#0%")
You may substitute the first argument with cell reference formula, then you can copy the formula to different cells.

The Excel TEXT function converts a supplied value into text, in a user-specified format.

The format of the function is :
TEXT( value, format_text )

Where the function arguments are:
value - A numeric value, that you want to be converted into text
format_text - A text string that defines the formatting that you want to be applied to the supplied value

The format definitions:
0 - Forces the display of a digit in its place
# - Display digit if it adds to the accuracy of the number (but don't display if a leading zero or a zero at the end of a decimal)
. - Defines the position that the decimal place takes

Example (formula in D2):
=TEXT((C2-B2)/C2,"#0%")


收錄日期: 2021-04-11 20:58:52
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20141220000051KK00046

檢視 Wayback Machine 備份