劉任昌excel串接字串concatenate試算表歷史

嵌入embed影片

嵌入網頁電子試算表發展歷史

excel常用函數

https://www.w3schools.com/excel/excel_functions.php

Function	Description
=AND	Returns TRUE or FALSE based on two or more conditions
=AVERAGE	Calculates the average (arithmetic mean)
=AVERAGEIF	Calculates the average of a range based on a TRUE or FALSE condition
=AVERAGEIFS	Calculates the average of a range based on one or more TRUE/FALSE conditions
=CONCAT	Links together the content of multiple cells
=COUNT	Counts cells with numbers in a range
=COUNTA	Counts all cells in a range that has values, both numbers and letters
=COUNTBLANK	Counts blank cells in a range
=COUNTIF	Counts cells as specified
=COUNTIFS	Counts cells in a range based on one or more TRUE or FALSE condition
=IF	Returns values based on a TRUE or FALSE condition
=IFS	Returns values based on one or more TRUE or FALSE conditions
=LEFT	Returns values from the left side of a cell
=LOWER	Reformats content to lowercase
=MAX	Returns the highest value in a range
=MEDIAN	Returns the middle value in the data
=MIN	Returns the lowest value in a range
=MODE	Finds the number seen most times. The function always returns a single number
=NPV	The NPV function is used to calculate the Net Present Value (NPV)
=OR	Returns TRUE or FALSE based on two or more conditions
=RAND	Generates a random number
=RIGHT	Returns values from the right side of a cell
=STDEV.P	Calculates the Standard Deviation (Std) for the entire population
=STDEV.S	Calculates the Standard Deviation (Std) for a sample
=SUM	Adds together numbers in a range
=SUMIF	Calculates the sum of values in a range based on a TRUE or FALSE condition
=SUMIFS	Calculates the sum of a range based on one or more TRUE or FALSE condition
=TRIM	Removes irregular spacing, leaving one space between each value
=VLOOKUP	Allows vertical searches for values in a table
=XOR	Returns TRUE or FALSE based on two or more conditions

以上的原始程式碼可copy然後html模式貼上

<h1>嵌入embed影片</h1>

<iframe width="560" height="315" src="https://www.youtube.com/embed/qVXZI4_mhIo?si=EMvuwGJlS36vdknw" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>

<h1>嵌入網頁電子試算表發展歷史</h1>

<iframe width="100%" height="315" src="https://zh.wikipedia.org/zh-tw/%E9%9B%BB%E5%AD%90%E8%A9%A6%E7%AE%97%E8%A1%A8"></iframe>

<h1>excel常用函數</h1>

https://www.w3schools.com/excel/excel_functions.php

<pre>

Function Description

=AND Returns TRUE or FALSE based on two or more conditions

=AVERAGE Calculates the average (arithmetic mean)

=AVERAGEIF Calculates the average of a range based on a TRUE or FALSE condition

=AVERAGEIFS Calculates the average of a range based on one or more TRUE/FALSE conditions

=CONCAT Links together the content of multiple cells

=COUNT Counts cells with numbers in a range

=COUNTA Counts all cells in a range that has values, both numbers and letters

=COUNTBLANK Counts blank cells in a range

=COUNTIF Counts cells as specified

=COUNTIFS Counts cells in a range based on one or more TRUE or FALSE condition

=IF Returns values based on a TRUE or FALSE condition

=IFS Returns values based on one or more TRUE or FALSE conditions

=LEFT Returns values from the left side of a cell

=LOWER Reformats content to lowercase

=MAX Returns the highest value in a range

=MEDIAN Returns the middle value in the data

=MIN Returns the lowest value in a range

=MODE Finds the number seen most times. The function always returns a single number

=NPV The NPV function is used to calculate the Net Present Value (NPV)

=OR Returns TRUE or FALSE based on two or more conditions

=RAND Generates a random number

=RIGHT Returns values from the right side of a cell

=STDEV.P Calculates the Standard Deviation (Std) for the entire population

=STDEV.S Calculates the Standard Deviation (Std) for a sample

=SUM Adds together numbers in a range

=SUMIF Calculates the sum of values in a range based on a TRUE or FALSE condition

=SUMIFS Calculates the sum of a range based on one or more TRUE or FALSE condition

=TRIM Removes irregular spacing, leaving one space between each value

=VLOOKUP Allows vertical searches for values in a table

=XOR Returns TRUE or FALSE based on two or more conditions

</pre>