Just like the AND function, the OR is a logical function in Excel. The OR function returns True if any of the given condition(s) are True. It only returns False if all the given conditions evaluate as False.
The AND is a logical function in Excel that determines if all the conditions in a test are TRUE. The other logical function examples are
The MOD function returns the remainder after a number is divided by the divisor. The general syntax is: = MOD(number, divisor)
The SUBTOTAL function in Excel is used to return the subtotal in terms of sum, average, count, max, min etc. for the specified list, named range or database.
Unlock the power of Excel Weekday Methods with our comprehensive guide at excel-learn.com. Learn the art of retrieving weekdays with ease through 5 examples.
The INDIRECT function is used when you require changing the reference to a cell in a formula while you do not want to change the formula itself.
if you require the count of cells that contain numbers only, use the Excel COUNT function.
To get the count of all cells with numbers, text, dates etc except the blank cells, use the COUNTA function. Similarly, for returning the count of cells based on certain criteriause the COUNTIFS function. To get the count of blank or empty cells, use the COUNTBLANK function.
There is no Excel SUBTRACTION function. Instead, you may accomplish the task of subtracting numbers or a cell’s value from the other by using the minus arithmetic operator (-).
The SUMPRODUCT function is used to multiply corresponding arrays or ranges and returns the sum. The SUMPRODUCT function is versatile.
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.
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 Excel SUMIFS function is used if you need to apply multiple criteria to get the sum of range.
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.