Doing Multiplication in Excel
You may simply use the ‘*’ operator e.g. 10*5, A2 * B2 or use the multiple operators in various functions. The PRODUCT function can also be used for multiplication of numbers and ranges.
You may simply use the ‘*’ operator e.g. 10*5, A2 * B2 or use the multiple operators in various functions. The PRODUCT function can also be used for multiplication of numbers and ranges.
Explore eight practical examples of using the Excel TEXT function to convert numbers and dates to custom text formats.
There are a numbers of ways in Excel to combine data for two or more cells in Excel. The technique and functions for merging data are:
Using CONCATENATE function
By using ‘&’ (ampersand sign)
TEXTJOIN function for merging ranges (Excel 2016, Excel online)
In this tutorial, I am going to show you how to create checkbox (also called tick box) in the Excel sheet. This is followed by a few examples of using it for different tables, so you can see checkboxes in action.
The CONCAENATION function combines two or more text string (as constant literals) or from different cells and returns a single combined string. You may also use ‘&’ ampersand sign for concatenating string/cells in Excel.
The line graph (also called line chart) is used to display the data graphically that change over the period of time.
The markers or data points in line chart are connected by the straight lines. Generally, the line charts are used for visualizing the trends over the intervals like year on year, or month on month etc.
The hyperlinks are useful for linking the other sheets or files and external URLs in cells of Excel. There is a number of ways for creating the Excel hyperlinks. Let us look at these ways one by one with examples.
The Excel SUMIFS function is used if you need to apply multiple criteria to get the sum of range.
For counting the number of characters in single or multiple cells, you may use the Excel LEN function. In the LEN function, you may provide a text string, cell or use LEN with SUM function for counting characters.
The Excel has a few functions like LEFT, MID, and RIGHT that can be used for getting the substrings from the given text, specified cell etc.
Whether text is based on external sources or written within Excel, you may remove the spaces on left and right of the text by using the TRIM function.
If you require sum of a range with certain condition then use the SUMIF function. If you separate SUM + IF, it already makes you understand why we use that.
The Excel INDEX function requires the position and range and returns the value based on that position. If you do not know the position, you may get this by using MATCH function.
In this tutorial, I will show you how to make dropdown list in Excel with examples. Not only will I show you ways of how to create dropdown but how to use its values in different formulas as well.
For getting the nearest multiple for any number like 5, 10, 100 etc. you may use the MROUND function in Excel. The MROUND function takes two arguments: MROUND(number, multiple)