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

[µo°Ý] excel°ÝÃD½Ð±Ð

[µo°Ý] excel°ÝÃD½Ð±Ð

½Ð±ÐÀx¦s®æ¼Æ­È¤£ÅÜ¥i¨Ì±ø¥ó¦b¼Æ­È¥¼ºÝ¥[¤J¤å¦rªº¤èªk

DEAR SIR
1.¦pªGRANGE("F12")¤º¬O¤½¦¡. ª½±µ¸Ó¤½¦¡§ï =IF(H12-0<0,¤½¦¡&"­t¼Æ",¤½¦¡)
2.IF RANGE("F12")»Ý¤â°Ê¿é¤JAA123456789.¿é¤J§¹°õ¦æ¦p¤U VBA
Sub AA()
X = Sheet1.[H65536].End(xlUp).Row
For Q = 12 To X
If Sheet1.Cells(Q, 8) - 1 < 0 Then
Cells(Q, 6).Value = Cells(Q, 6).Value & "­t¼Æ"
End If
Next
End Sub
ù

TOP

­Y¬Oª½±µ¥ÎEXCEL¨Ó¸Ñ¡A¥i¥H±N¤½¦¡¼g¦¨=IF(D2<0,A2&"­t¼Æ",A2)¡A§Y¬°©Ò¨D¡C

TOP

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