[實用軟件] 可否簡化

=IF(F19<60,"< 1 hr",IF(AND(F19>59,F19<90),"1 - 1.5 hr",IF(AND(F19>89,F19<151),"1.5 - 2.5 hrs",IF(AND(F19>150,F19<241),"2.5 - 4 hrs",IF(F19>240,"> 4 hrs")))))

這個將時間長度歸入不同類別的公式能否簡化?

=IF(F19<60,"< 1 hr",IF(F19<=90,"1 - 1.5 hr",IF(F19<=150,"1.5 - 2.5 hrs",IF(F19<=240,"2.5 - 4 hrs","> 4 hrs"))))

TOP

回覆 2# stanleymm

yes, thankyou

TOP

formula : =INDEX(B1:B4,MATCH(D1,A1:A4,1),1)
附件: 您需要登錄才可以下載或查看附件。沒有帳號?註冊

TOP

相關文章