Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
data_analysis:excel [2023/06/21 04:43] – [Excel] prgram | data_analysis:excel [2025/07/07 14:12] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 15: | Line 15: | ||
- 값을 행으로 넣기 | - 값을 행으로 넣기 | ||
- | substitute | + | substitute |
https:// | https:// | ||
+ | <code vb> | ||
+ | =LAMBDA(text, | ||
+ | </ | ||
+ | |||
+ | #DIVS 에러 처리 | ||
+ | <code vb> | ||
+ | =LET( x, sumifs( A2/B2 ), IF(x = 0, "", | ||
+ | =iferror(1/ | ||
+ | </ | ||