excel "if"

💰 財經台其他 - 商業及金融

用戶193803

2007-07-20 5:27 pm

咁多位...可唔可以幫我set條formula~~~
用黎計強積金~~

如果v6>=5000, 就要將v6*5%~~如果v6>=20000, 就會等於1000
如果v6細過5000,就唔洗計..

我set 黎set去..都set唔到....
唔識一次過set formula

回答 (2)

wahding

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

👍 0 👎 0

Andy Chan

2007-07-20 11:01 pm

=IF(V6>20000,1000,IF(V6>5000,V6*5%,0))

👍 0 👎 0