咁多位...可唔可以幫我set條formula~~~
用黎計強積金~~
如果v6>=5000, 就要將v6*5%~~如果v6>=20000, 就會等於1000
如果v6細過5000,就唔洗計..
我set 黎set去..都set唔到....
唔識一次過set formula
excel "if"
2007-07-20 5:27 pm
回答 (2)
2007-07-20 6:19 pm
✔ 最佳答案
See the formulae below:=IF(V6<5000,0,(IF(V6<=20000,V6*5%,1000)))
You can just copy and paste in the excel cell
2007-07-20 11:01 pm
=IF(V6>20000,1000,IF(V6>5000,V6*5%,0))
收錄日期: 2021-04-13 01:01:05
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070720000051KK00691