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

[µo°Ý] IF¦h­«§PÂ_¡A½ÐÀ°¦£¡AÁÂÁÂ!(VBA¼gªkÂন¨ç¼Æ¼gªk)

[µo°Ý] IF¦h­«§PÂ_¡A½ÐÀ°¦£¡AÁÂÁÂ!(VBA¼gªkÂন¨ç¼Æ¼gªk)

1.jpg

¼g¦bG3Àx¦s®æ

±N¦¹VBA¼gªk§ï¦¨¨ç¼Æ¼gªk

If Sheets("¤u§@ªí1").Cells(I, "D") < 0.5 Then

Sheets("¤u§@ªí1").Cells(I, "G") = "·s¤H"

ElseIf Sheets("¤u§@ªí").Cells(I, "F") = "³¯«³¨³" Or Sheets("Assy1").Cells(I, "F") = "¼B¼wµØ" Then

Sheets("¤u§@ªí").Cells(I, "G") = "leader"

ElseIf Sheets("¤u§@ªí1").Cells(I, "F") = "±i¾Ç¤Í" Or Sheets("¤u§@ªí").Cells(I, "F") = "³¢´I«°" Then

Sheets("¤u§@ªí1").Cells(I, "G") = "leader(¥N)"

ElseIf Sheets("¤u§@ªí1").Cells(I, "F") = "§õµOÄ£" Or Sheets("¤u§@ªí1").Cells(I, "F") = "³¢¥x»Ê" Or Sheets("¤u§@ªí1").Cells(I, "F") = "¤p½¼" Then

Sheets("¤u§@ªí1").Cells(I, "G") = "°V½m­û"

ElseIf Sheets("¤u§@ªí1").Cells(I, "F") = "Í×´¼·½" Or Sheets("¤u§@ªí1").Cells(I, "F") = "¾¤©ú" Then

Sheets("¤u§@ªí1").Cells(I, "G") = "LAB±M­û"

ElseIf Sheets("¤u§@ªí1").Cells(I, "F") > 0.5 Then

Sheets("¤u§@ªí1").Cells(I, "G") = "¦Ñ³¾"

End If

Next

¨ÌÃD·N, ³Ì¦n«Ø¹ï·Óªí, ¥H VLOOKUP ¨ú¹ïÀ³­È,
µo©«®É³Ì¦n³sÀɮפ]¤W¶Ç, ¥u¦³¤å¦r´y­z©Î¹Ï¤ù, «ÜÃøÀò±o¾A¤ÁªºÀ°§U!

TOP

IF¨ç¼Æ³Ì¦h¥u¯à¥Î7¼h¡A©Ò¥H§ó¦h±o¼h¼Æ´N¥i¥H¨Ï¥Î¬d¸ß¨ç¼Æ¦pVLOOKUP¡BLOOKUP...µ¥¸û²³æ

G3=IF(D3<0.5,"·s¤H",IFERROR(VLOOKUP(F3,{"³¯«³¨³","leader";"¼B¼wµØ","leader";"±i¾Ç¤Í","leader(¥N)";"³¢´I«°","leader(¥N)";"§õµOÄ£","°V½m­û";"³¢¥x»Ê","°V½m­û";"¤p½¼","°V½m­û";"Í×´¼·½","LAB±M­û";"¾¤©ú","LAB±M­û"},),"¦Ñ³¾")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD