-
Excel Tutorial – FactDouble
Read More: Excel Tutorial – FactDoubleThe FACTDOUBLE function in Microsoft Excel is a math and trigonometry function that calculates the double factorial of a number. The double factorial of a number is the product of all the integers from 1 up to the number, but only counting every other number. For example, the double factorial of 6 is 6 x…
-
Excel Tutorial – Evaluate
Read More: Excel Tutorial – EvaluateThe EVALUATE function in Microsoft Excel is a formula evaluation function that allows you to execute a formula or expression as a string. Here’s a step-by-step guide on how to use the EVALUATE function: Open your Microsoft Excel spreadsheet and select the cell where you want to display the result of the formula or expression.…
-
Excel Tutorial – ROMAN
Read More: Excel Tutorial – ROMANThe ROMAN function in Microsoft Excel is a math and trigonometry function that converts a number to Roman numerals. Here’s a step-by-step guide on how to use the ROMAN function: Open your Microsoft Excel spreadsheet and select the cell where you want to display the converted number. Type the following formula into the selected cell:…
-
Excel Tutorial – BAHTTEXT
Read More: Excel Tutorial – BAHTTEXTThe BAHATTEXT function in Microsoft Excel is a financial function that converts a number to text in Thai Baht currency format. Here’s a step-by-step guide on how to use the BAHATTEXT function: Open your Microsoft Excel spreadsheet and select the cell where you want to display the converted number. Type the following formula into the…
-
Excel Tutorial – RANDARRAY
Read More: Excel Tutorial – RANDARRAYThe RANDARRAY function in Microsoft Excel is a function that generates a range of random numbers in a range of cells. This function is useful for generating data in Excel and for creating random number lists. To use the RANDARRAY function, follow these steps: Open Microsoft Excel and select the cell where you want the…
-
Excel Tutorial – SEQUENCE
Read More: Excel Tutorial – SEQUENCEThe SEQUENCE function in Microsoft Excel is a function that generates a list of sequential numbers in a range of cells. This function is useful for creating lists of numbers and for generating data in Excel. To use the SEQUENCE function, follow these steps: Open Microsoft Excel and select the cell where you want the…
-
Excel Tutorial – SORTBY
Read More: Excel Tutorial – SORTBYThe SORTBY function in Microsoft Excel is a function that sorts a range of cells based on the values in one or more columns, and returns the sorted range as an array. This function is useful for sorting and organizing data in Excel. To use the SORTBY function, follow these steps: Open Microsoft Excel and…
-
Excel Tutorial – XMATCH
Read More: Excel Tutorial – XMATCHThe XMATCH function in Microsoft Excel is a function that searches for a value in a range of cells and returns the relative position of the value in the range. This function is similar to the VLOOKUP function, but it allows you to specify the match type (exact, approximate, or wildcard) and returns the position…
-
Excel Tutorial – TEXT
Read More: Excel Tutorial – TEXTThe TEXT function in Microsoft Excel is a function that converts a value to text, using a specified format. This function is useful for formatting and displaying numbers and other data types as text in Excel. To use the TEXT function, follow these steps: Open Microsoft Excel and select the cell where you want the…
-
Excel Tutorial – EXACT
Read More: Excel Tutorial – EXACTThe EXACT function in Microsoft Excel is a function that compares two text strings and returns the value TRUE if the strings are exactly the same, and FALSE if they are not. This function is useful for comparing text data in Excel and determining if two strings are identical. To use the EXACT function, follow…
