[구글스프레드시트] 수식만으로 곱셈(구구단)을 시각적으로 표현( sequence,text,regexreplace)
Page info
Writer EXCEL AND VBA Date21-10-10 00:00 Hit35 Comment0Link
-
https://youtu.be/Z9F-R5fl9k8
14- Connection
Body
#구구단 #곱셈 #sequence #text #regexreplace #정규표현식
--------------------------------------------------------------------------------\r
좋아요/구독 눌러주세요. 큰 힘이 됩니다.\r
--------------------------------------------------------------------------------\r
질문 사항이 있으시면 kim5953@gmail.com으로 해 주세요.
[File Link]
https://docs.google.com/spreadsheets/d/1IlpIksQhDJ_nFLhXUhYoFlWaZX6DOUD_Jujqt7J1DaA/edit?usp=sharing
[Formulas]
=ARRAYFORMULA( regexreplace( text(SEQUENCE(I1,C1,1,1),"0"), "[0-9]{1,}","K") )
="=" \u0026 substitute(trim(rept(" " \u0026 C1 \u0026 " ",I1))," ","+")
--------------------------------------------------------------------------------\r
좋아요/구독 눌러주세요. 큰 힘이 됩니다.\r
--------------------------------------------------------------------------------\r
질문 사항이 있으시면 kim5953@gmail.com으로 해 주세요.
[File Link]
https://docs.google.com/spreadsheets/d/1IlpIksQhDJ_nFLhXUhYoFlWaZX6DOUD_Jujqt7J1DaA/edit?usp=sharing
[Formulas]
=ARRAYFORMULA( regexreplace( text(SEQUENCE(I1,C1,1,1),"0"), "[0-9]{1,}","K") )
="=" \u0026 substitute(trim(rept(" " \u0026 C1 \u0026 " ",I1))," ","+")
Comment List
There are no registered comments.
패밀리사이트 더보기
문의/제안 : 