如CELL C = CELL A x CELL B, 同時我想set CELL A x CELLB出黎既result 不能大過一個指定數值(即我想set個maxium value比CELL C),如大過指定數值,最多只能show到個MAXIUM VALUE, 我應該點SET?
例: CELL A = 10, CELL B = 20 , CELL C MAXIUM VALUE = 150
正常: 10 x 20 = 200
set左formula佢自動會show : 10 x 20 = 150
thank you~
excel問題-急
2007-10-09 7:16 pm
回答 (2)
2007-10-09 9:40 pm
✔ 最佳答案
=IF(A1*B1<=150, A1*B1, 150)2007-10-09 13:47:20 補充：
shin_bingo_dog君的答案是對的. 解作 the entity used to represent a non-breaking space. It is essentially a standard space, the primary difference being that a browser should not break (or wrap) a line of text at the point that this occupies. (意思是在 這位置不分行)
2007-10-09 7:26 pm
=IF(A1*B1<=150, A1*B1, 150)
收錄日期: 2021-04-13 13:50:18
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071009000051KK00832