|
||
0
0
Àϴܿø²
´õ½ÚÄ«µå´Â ÀÌ¿ë¾ÈÇϽ󪿵?
2021-09-22
|
0
0
ÇÑÈ·ùÇöÁø
A1 - INT(A1/1000)*1000 MOD(A1,1000) ÇϼŵµµË´Ï´Ù.
2021-09-22
|
0
0
qomputer
¿©±â °í±Þ ÀηºеéÀÌ ¸¹±º¿ä 👍🏻
2021-09-22
|
0
0
[* ºñȸ¿ø *]
=IF(AND(OR(INDIRECT(ADDRESS(ROW(),MATCH("ÀÌ¿ëÄ«µå",$1:$1,0),4))="´õ¸ð¾Æ1", INDIRECT(ADDRESS(ROW(),MATCH("ÀÌ¿ëÄ«µå",$1:$1,0),4))="´õ¸ð¾Æ2"), INDIRECT(ADDRESS(ROW(),MATCH("ÀÌ¿ë±Ý¾×",$1:$1,0),4))>5000), (1+OR(ISNUMBER(SEARCH({"¿ì¾ÆÇÑ","¿ä±â¿ä","ÀÚµ¿ÀÌü","·Ôµ¥¼î"}, INDIRECT(ADDRESS(ROW(),MATCH("°¡¸ÍÁ¡¸í",$1:$1,0),4))))))*MOD (INDIRECT(ADDRESS(ROW(),MATCH("ÀÌ¿ë±Ý¾×",$1:$1,0),4)),1000))
³ªÁß¿¡ ´Ù½Ã º¸½ÇºÐÀ» À§ÇØ... ÀÌ°Å ÀÌ¿ë³»¿ª ¿À¸¥ÂÊ ºóÄ ¾Æ¹«µ¥³ª ³ÖÀ¸¸é µË´Ï´Ù. (Áß°£¿¡ ¿£ÅÍÄ£°Å´Â ´Ù ¾ø¾ÖÁÖ¼¼¿ä)
´õºíÀû¸³ Ç׸ñÀº º»ÀÎ ¿©°Ç¿¡ ¸Â°Ô~ * ÇØ¿Ü»ç¿ë, ÇÏ·ç °°Àº°¡¸ÍÁ¡ Áߺ¹Àº..... ³ ¸ð¸£°ÚÀ½
2022-01-07 *
|
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | -¸ñ·Ïº¸±â |