A little about 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
What is Excel MOD function?
The MOD function returns the remainder after a number is divided by the divisor. The general syntax is: = MOD(number, divisor)
Purpose of 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.
The Weekdays in Excel
There are a few ways of getting the Weekday in Excel. if you require the number of day in a Week for the given date then may use then WEEKDAY function. If you require short day name then use the TEXT function
The INDIRECT function in Excel
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 Count 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.
The TEXT function in Excel
The Excel TEXT function can be used to convert numbers and dates into text. This is particularly useful for scenarios where you require displaying the numbers or dates with text strings. For example:
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 for removing spaces
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.
What is SUMIF function in Excel?
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.
