Excel XOR Function ( 3 Unique Examples)
Excel XOR Function The excel XOR function performs “exclusive OR” of all arguments. The XOR function has two logical statements, and it returns returns TRUE if either statement is TRUE. It returns FALSE if both statements are TRUE. If none is TRUE, XOR also returns FALSE. In this section: Advertisements Syntax of XOR function Create […]
Excel OR Function ( 5 Examples)
Excel OR Function Excel OR Function returns TRUE if any given arguments are TRUE, and returns FALSE if all the arguments are FALSE. For example, to test the value in C6 for greater than 80 OR equal to 90, users use =OR(C6>80, C6=90). Users can use the OR function as the logical test inside the […]
Excel NOT Function (5 examples)
Excel NOT Function Excel NOT Function is used to return the opposite of given logical or Boolean value. When the given condition is TRUE, the NOT function returns FALSE. If it is used with expression TRUE, it returns FALSE, and vice verse. In this section: Advertisements Syntax of NOT Function Example 1: NOT with OR […]
Excel IFS Function (5 examples)
Excel IFS Function The Excel IFS function runs multiple tests and returns a value that corresponds to the first TRUE condition. IFS is more powerful than the IF function because IFS can be used in place of multiple nested IF statements. The formula of IFS is much easier, shorter, and to the point. In this […]
Excel IFNA Function ( 3 examples)
Excel IFNA Function Excel IFNA function returns the value users specify if a formula returns the #N/A error value; otherwise, it returns the result of the formula. The Excel MATCH, VLOOKUP, HLOOKUP, XLOOKUP functions return #N/A error if they do not find the desired match of the values. Users can use the IFNA function to trap […]
Excel IFERROR Function (4 examples)
Excel IFERROR Function Excel IFERROR function is used to trap and handle errors in a formula. The excel IFERROR function returns a value users specify if a formula evaluates to an error; otherwise, it returns the result of the formula. Advertisements In this section: Syntax of IFERROR Example 1: Replace #DIV/0! error with zero (0) […]
Excel FALSE Function (4 Examples)
Excel FALSE Function The Boolean value (as it is in TRUE=1, FALSE=0) FALSE is generated by Excel FALSE Function. Users do not need to use any arguments for FALSE Function. The main objective of the Excel FALSE function is to generate the FALSE logical value. In this section: Advertisements Syntax of FALSE Function Example 1: […]
How to Remove Unnecessary Characters (5 Examples)
Remove Unnecessary Characters in Excel Sometimes, we have uncleaned data. We need to remove unnecessary characters or texts. We can use Excel SUBSTITUTE function to remove these characters. In this section: Advertisements Remove unnecessary characters from texts Extract the title of the page from URL Remove unnecessary space between texts
Excel AND Function (5 Examples)
Excel AND Function Excel AND Function is used to test whether all the conditions in a test are TRUE. The AND function returns TRUE if all its arguments evaluated are TRUE, and returns FALSE if one or more arguments evaluated is FALSE. If both scores in Math and Statistics are more than 80 {=AND(C6>80, D6>80) […]
Tableau Data Analytics
Tableau Data Analytics Tableau Data Analytics is basically used to visualize data, and users can choose from different visualization tools such as Bar chart, Pie Chart, Maps, and so on. In this section: Advertisements Tableau Desktop Window Showing best performer in Bar Diagram. Adding color to different sales representatives. Calculate new field. Who is best […]