ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] EXCEL¨ç¼Æ(IF)¨D¸Ñ (¤j©ó¤p©ó°ÝÃD)

[µo°Ý] EXCEL¨ç¼Æ(IF)¨D¸Ñ (¤j©ó¤p©ó°ÝÃD)

EXCEL¨ç¼Æ(IF)¨D¸Ñ               
·íA1¤p©ó5,
¦bB1Åã¥Ü1,               
¤j©óµ¥©ó5¥B¤p©ó10Åã¥Ü2,               
¤j©óµ¥©ó10¤p©ó15,Åã¥Ü3,               
¤j©óµ¥©ó15¤p©ó20Åã¥Ü4,               
¤j©óµ¥©ó20Åã¥Ü5

¦^´_ 2# hcm19522

¤wª¾
A1B1C1D1E1
¤À§O¬O34.25           21.74590339         24.71933467        30.66619724        33.63962852
§Ú·Qª¾¹D34.5¬O¦b¨º­Ó¦ì¸m
¤p©óB1¬O1,
¦bB1©MC1¤§¶¡¬O2,
¦bC1©MD1¤§¶¡¬O3,
¦bD1¸òE1¤§¶¡¬O4,
¤j©óE1¬O5

TOP

¦^´_ 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
¬°¤°»ò¤@©w­n¨ì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,"")))))
¬°¤°»ò¤£¦æ?

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD