[µo°Ý] ½Ð°Ý¦p¦ó¦b¦Û­q¨ç¼Æ¤¤¥[¤Jifªº¨ç¼Æ?

´Ñ»y³¾»ï

¤U­±¬O¤p§Ì·Q°µªºFunction¡A¤£¹L¦]¬°¦³ifªºÃö«Y¡A
·|¥X²{¿ù»~!½Ð°Ý¦U¦ì¤j®v­n¦p¦ó­×§ï¨Ï¯à¥¿±`¨Ï¥Î¦¹Function

1. Public Function AAA(Range1, Range2)
   
2. AAA =IF(Range1=""-"",""Ĺ"",IF(Range2>Range1,""¿é"","" ""))
   
3. End Function

½Æ»s¥N½X

oobird

1. Public Function AAA(Range1, Range2)
   
2. If Range1 = "-" Then
   
3. AAA = "Ĺ"
   
4. ElseIf Range2 > Range1 Then
   
5. AAA = "¿é"
   
6. End If
   
7. End Function

½Æ»s¥N½X

GBKEE

¦^´_ 1# ´Ñ»y³¾»ï

1. Public Function AAA(Range1, Range2)
   
2.     AAA = IIf(Range1 = "-", "Ĺ", IIf(Range2 > Range1, "¿é", " "))
   
3. End Function

½Æ»s¥N½X

´Ñ»y³¾»ï

¦^´_ 3# GBKEE
¦^´_ 2# oobird
­ì¨ÓÁÙ¦³³oºØ¤èªk¡A½Ð°ÝGBKEE¤j¤j !  iif¸òif®t¦b­þ??

GBKEE

¦^´_ 4# ´Ñ»y³¾»ï
¦h±ø¥ó¿ï¾Ü ,³æ¤@±ø¥ó¿ï¾Ü
If...Then...Else ³¯­z¦¡ : ®Ú¾Ú¬Y¹Bºâ¦¡ªº­È¨Ó¨M©w­n°õ¦æ­þ¨Ç³¡¥÷ªº³¯­z¦¡¡C
If ¹Bºâ¦¡.Then
...
Elseif ¹Bºâ¦¡  then
...
Elseif¹Bºâ¦¡   then
...
Else   '=>©Ò¦³¹Bºâ¦¡1j¤£¦¨¥ß
...
endif
'''''''''''''''
IIf ¨ç¼Æ:  ®Ú¾Ú¬Y¹Bºâ¦¡ªº­È¡A¨Ó¶Ç¦^¨â³¡¥÷¤¤ªº¨ä¤¤¤@­Ó¡C
AAA = IIf(Range1 ="-", "Ĺ", IIf(Range2 > Range1, "¿é", " "))
²Ä¤@³¡¥÷   "Ĺ"
²Ä¤G³¡¥÷    IIf(Range2 > Range1, "¿é", " ")

´Ñ»y³¾»ï

¦^´_ 5# GBKEE


    ­ì¨Ó¦p¦¹~§ÚÀ´¤F!c¤j¯uªº¬O³Õ¾Ç¦h»D!Åý§Ú¨ü¯q­ê²L!