Excel OR Function
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.
Excel Functions
What is Excel AND function?
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
Excel MOD Function
The MOD function returns the remainder after a number is divided by the divisor. The general syntax is: = MOD(number, divisor)
Excel SUBTOTAL Function
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.
Weekdays in Excel
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.
Excel INDIRECT Function
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.
How to use Count Function in Excel?
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.
How to subtract in Excel?
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 (-).
What is SUMPRODUCT Function in Excel?
The SUMPRODUCT function is used to multiply corresponding arrays or ranges and returns the sum. The SUMPRODUCT function is versatile.
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.
TEXT Function in Excel
Explore eight practical examples of using the Excel TEXT function to convert numbers and dates to custom text formats.
How to Concatenate in Excel (Strings and cells)?
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 SUMIFS Function in Excel
The Excel SUMIFS function is used if you need to apply multiple criteria to get the sum of range.
Excel TRIM Function
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.
Excel SUMIF 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.
