excel如何自動帶入

[匿名]

2014-07-24 7:02 pm

如何在A1輸入(0~280,281~350之間的值)則A2會顯示(20,80)

回答 (5)

[匿名]

2014-07-28 10:47 am

✔ 最佳答案

>這家不錯 lｖ3３3。ｃC買幾次啦真的一樣
卷佴吲

👍 0 👎 0

AVXOSUFKDZLM

2014-07-26 9:32 am

到下面的網址看看吧

▶▶http://*****

👍 0 👎 0

[匿名]

2014-07-25 8:21 pm

=IF(AND(A1>=0,A1<=280),20,IF(AND(A1>=281,A1<=350),80,""))

👍 0 👎 0

EXCEL迷

2014-07-25 12:36 am

=IF(A1>280,80,20)

👍 0 👎 0

[匿名]

2014-07-24 11:46 pm

A2=LOOKUP(A1,{0,281},{20,80})

👍 0 👎 0

收錄日期: 2021-04-27 21:15:27
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20140724000010KK03927

檢視 Wayback Machine 備份