- ©«¤l
- 40
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 97
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW¥x«n
- µù¥U®É¶¡
- 2016-8-26
- ³Ì«áµn¿ý
- 2018-10-31
|
¦^´_ 4# hcm19522
hcm19522¤j¡A¥i¥H¤F¡A¸U¤À·PÁ¡C
¤£¦º¤ßªº§ÚÁÙ¬OGOOGLE¤F©_¼¯ª¾ÃÑ·Q§ä¥Xµª®×
https://tw.answers.yahoo.com/question/index?qid=20070622000015KK06184
I1=IF(B1<E1,1,IF(AND(B1>=E1,B1<F1),2,IF(AND(B1>=F1,B1<G1),3,IF(AND(B1>=G1,B1<H1),4,IF(B1>=H1,5,"")))))
I1=IF(B1>=H1,5,IF(AND(B1<H1,B1>=G1),4,IF(AND(B1<G1,B1>=F1),3,IF(AND(B1<F1,B1>=E1),2,IF(AND(B1<E1),1,"")))))
ªþµù:B1¬O¸ê®Æ¡A¨ä¥L¹ï·Ó°Ï¶¡¦bE1F1G1H1
§Úªº°ÝÃD¬O
¬°¤°»ò¤@©wn¨ìAND¨ç¼Æ¡A¦pªG¥Î
I1==IF(B1<E1,1,IF(E1<=B1<F1,2,IF(F1<=B1<G1,3,IF(G1<=B1<H1,4,IF(B1>=H1,5,"")))))
¬°¤°»ò¤£¦æ? |
|