”IF” EXCEL FUNCTION // URGENT

2010-04-10 11:18 pm
HOW TO SET UP FORMULA UNDER EXCEL ?
MY REQUIREMENT IS
IF THE ANSWER >100 ="0%"
IF THE ANSWER <100 = REAL ANSWER

EXAMPLE

A2 = 98% => IT SHOW "0%"
B2 = 102% => ITSHOW "2%"

THANKS TO ADV
更新1:

thanks your quick answer can we have 2if function together on 1cell i would like to have answer on each cell is if <100 =>0% if >100 => real answer , example under "b2",answer is 102%, then result should be 2% thanks

回答 (2)

2010-04-14 9:16 pm
✔ 最佳答案
我相信只用一個 if 就足夠了, 不必用 nested if.
設 數目在 A1, 在 B1 輸入
=IF(A1<100%, "0%", TEXT(A1-1,"#%"))
就可以了.
2010-04-10 11:34 pm
=IF(A2<1,"0%",TEXT(A2-1,"0%"))

assume your enter 98% (0.98) in A2


------------------------------
http://www.excelhelp.net
http://kimbalko.blogspot.com

2010-04-10 21:26:27 補充:
am... do you means:

if A2<=100 then 0%
otherwise, if A2>100, check B2<=100
if B2 <=100 then display 0%, if not display B2-100 ?


=IF(A2<1,"0%",IF(B2<1,"0%",TEXT(B2-1,"0%")))


收錄日期: 2021-04-20 15:25:59
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100410000051KK00837

檢視 Wayback Machine 備份