ªð¦^¦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

'=LOOKUP(A1,{0,5,10,15,20},{1,2,3,4,5})
©Î=INT(A1/5)+1
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 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

¦^´_ 3# paul3063

=SUMPRODUCT(N(34.5>B1:E1))+1
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

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

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2017-12-18 10:15 ½s¿è

¦^´_ 5# paul3063

¤åªk¤£¹ï ,AND¬°¤G±ø¥ó§¡¦¨¥ß ¤~¬°¯u OR¤£¦æ
E1<=B1<F1-->E1<=¯u©Î°² (B1<F1)-->¼Æ¦r<¤¤¤å ,©Ò¥H¥¢¯u
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ inhogold ©ó 2017-12-18 11:26 ½s¿è

¥i½Ð°Ý¤j¤j­Ì~
°²³]§Ú¥u¬O¤j©ó¹s¥H¤Î¤p©ó¹sªº¸Ü¡A§Ú¥ÎIF¡A¥i¬O«o¨S¦³¶Ç¦^§Ú­nªº1¸ò-1
¬O¤£¬O§Úªº¤½¦¡ÁÙ¬O»{ª¾¤W¦³»~¡A¥i½Ð½ç±Ð¶Ü??

¤j©ó¹s¤p©ó¹s.png (101.23 KB)

¤j©ó¹s¤p©ó¹s.png

¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 7# inhogold


    ¥ª¤W¦³ºñ¦â¤p¨¤¡A¥Nªí¬°¤å¦r«¬ºA¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/NYkSdB
¡@¬G»Ý±N¤å¦r«¬ºAÂà´«¦¨¼Æ­È«¬ºA¡A¦A§PÂ_¬O§_¤p©ó0
2017-12-18_123716.png

TOP

ÁÂÁÂjoblyc017¤jªº¸Ñµª
½Ð°Ýjoblyc017¤j
«ö±z©Ò³sµ²ªººô§}¤w¸Ñ¨M§Úªº°ÝÃD¡A
§Ú¥Î±zªº¨ç¼Æ=IF(--(B2)<0,-1,1)¡A
«á¨Ó¹Á¸Õ¥Î    =IF((B2)<0,-1,1)¡A
¥L¤]¬O¥i¥H¡A¥i¥H½Ð°Ý¦h¤F--<=====¥L¬O¦³¬Æ»ò¯S§Oªº·N¸q¶Ü?
³Â·Ð±z¸Ñ´b¤F,¦A¦¸·PÁ±z!!
¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 9# inhogold


    §Úªº½d¨Òºû«ùµÛ¤å¦r«¬ºA¡A¨Ã¨S¦³¹B¥Îºô§}¤ºªº¤è¦¡¡A¥ýÂà´«¦¨¼Æ­È«¬ºA
    - ¬°­t¼Æ¡A -- ¥Nªí­t­t±o¥¿¡A¥i±N¤å¦r«¬ºAÂà´«¦¨¼Æ­È«¬ºA

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD