If ¦h±ø¥ó

yc1031

IF - 3­Ó±ø¥ó.rar (8.11 KB)

¤U¸ü¦¸¼Æ: 8

2012-8-21 14:58

¦U¦ì¦n!
·Q½Ð°Ý if ¨ç¼Æªº¹B¥Î
¦bªþ¥ó¤¤,   ºÞ¾P¦³¤TºØ±¡ªp
1.  ¥¿±`±¡ªp ( §Y¬O HD&LD ¥­§¡¥¼¶W¹L1600, HD ¤]¥¼¶W¹L1300)
2.  §é¦©1 (§Y¬O HD&LD ¥­§¡¶W¹L1600)
3.  §é¦©2 (§Y¬O HD ¶W¹L1300)

*  ¤GºØ§é¦©¤£¯à¨Ã¦s
*  ¦P®É¤G­Ó§é¦©³£²Å¦X®É, ­n¥H§é¦©1¬°¥D

½Ð±Ð¦U¦ì, §Ú¨ç¼Æ¸Ó¦p¦ó¼g©O?

yc1031

IF - 3­Ó±ø¥ó.rar (8.14 KB)

¤U¸ü¦¸¼Æ: 9

2012-8-21 15:30

½Ð¥H¦¹ªþ¥ó¬°¥D, ÁÂÁÂ!

lalalada

¦^´_ 2# yc1031
¤½¦¡:   =IF(B3>=1600,VLOOKUP(D6,A10:B12,2,0),IF(B3>=1300,VLOOKUP(D6,A14:B16,2,0),VLOOKUP(D6,A6:B8,2,0)))

aer

=IF(AND(B3>=1600,OR(B1>=1300)),VLOOKUP(D6,A10:B12,2,0),IF(AND(B3<1600,OR(B1>=1300)),VLOOKUP(D6,A14:B16,2,0),VLOOKUP(D6,A6:B8,2,0)))

yc1031

¦^´_ 3# lalalada


  ¦¨¥\¤F!

  ÁÂÁ±zªº¨ó§U~

yc1031

¦^´_ 4# aer


¤]ÁÂÁ±z´£¨Ñªº§@ªk, ¦³ÂI¤p°ÝÃD, ¤£¹L§Ú·Q¤½¦¡¥»¨­¬O¨S°ÝÃD, §Ú¦Û¤v¦b¸Ì­±ªº³W«h°Ê¤@¤U´N¦n¤F!¡@¡@¦A¦¸ÁÂÁ¡I¡@

=IF(AND(B3>=1600,(B1>=1300)),VLOOKUP(D6,A10:B12,2,0),IF(AND(B3<1600,OR(B1>=1300)),VLOOKUP(D6,A14:B16,2,0),VLOOKUP(D6,A6:B8,2,0)))