Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Excel Bar Chart
  • How To Compare Two Lists in Excel
  • Working With Tables in Excel
  • Understanding Pivot Tables in Excel

References

  • To count total rows in a range in Excel
  • Two-column Lookup in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Lookup entire row in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation allow uppercase only
  • Excel Data validation no punctuation
  • Excel Data validation number multiple 100
  • Excel Data validation date in next 30 days

Tag: NOT function

IF, AND, OR and NOT Functions Examples in Excel

by

Learn how to use Excel’s logical functions such as the IF, AND, OR and NOT function. If The IF function checks whether a condition is met, and returns one value if true and another value if false. 1. For example, take a look at the IF function in cell C2 below. Above Case Study Explanation: if the …

Continue Reading

NOT function: Description, Usage, Syntax, Examples and Explanation

by

What is NOT function in Excel? NOT function is one of the Logical functions in Microsoft Excel that is used when you want to make sure one value is not equal to another. Examples of NOT function Examples Here are some general examples of using NOT by itself, and in conjunction with IF, AND and OR. Formula Description =NOT(A2>100) A2 is NOT greater than 100 …

Continue Reading

How to test for all values in a range are at least in Excel

by

To test if all values in a range are at least a certain threshold value, you can use the COUNTIF function together with the NOT function. Formula =NOT(COUNTIF(range,”<65″)) Explanation In the example shown, the formula in G5 is: =NOT(COUNTIF(B5:F5,”<65″)) How this formula works At the core, this formula uses the COUNTIF function to count any …

Continue Reading

If NOT this or that in Excel

by

This tutorial shows how to calculate If NOT this or that in Excel using the example below; Formula =IF(NOT(OR(A1=”red”,A1=”green”)),”x”,””) Explanation If you want to do something specific when a cell is NOT this or that (i.e. is NOT equal to X or Y, etc.) you can use the IF function in combination with the NOT and OR functions …

Continue Reading

If cell is not blank in Excel

by

This tutorial shows how to calculate If cell is not blank in Excel using the example below; Formula =IF(A1<>””,”Not blank”,”Blank”) Explanation If you want to test a cell and take some action if the cell is not blank (not empty), you can use a simple formula based on the IF function. In the example shown, we have …

Continue Reading

Highlight column differences in Excel

by

This tutorial shows how to Highlight column differences in Excel using the example below; Formula =$A1<>$B1 Explanation If you want to highlight the differences between two columns of data with conditional formatting you can do so with a simple formula that uses the” not equal to” operator (e.g. <>) and mixed references. For example, if you …

Continue Reading

Count cells that do not contain errors in Excel

by

This tutorial shows how to Count cells that do not contain errors in Excel using the example below; Formula =SUMPRODUCT(–NOT(ISERR(range))) Explanation To count the number of cells that contain errors, you can use the ISERR and NOT functions, wrapped in the SUMPRODUCT function. In the example, the active cell contains this formula: =SUMPRODUCT(–NOT(ISERR(B4:B8))) How this …

Continue Reading

Count cells that contain numbers in Excel

by

This tutorial shows how to Count cells that contain numbers in Excel using the example below; Formula =COUNT(range) Explanation To count the number of cells that are not blank, use the COUNT function. In the example, the active cell contains this formula: =COUNT(B4:B8) How this formula works The COUNT function is fully automatic. It counts the …

Continue Reading

How to use Excel NOT Function

by

This Excel tutorial explains how to use the NOT function with syntax and examples. Excel NOT Function Description The Excel NOT function returns the opposite to a supplied logical value. That is, If supplied with the value TRUE, the Not function returns FALSE; If supplied with the value FALSE, the Not function returns TRUE. Excel …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • IF function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • How to calculate nth day of week in month in Excel
  • How to calculate percent of year complete in Excel
  • Series of dates by day
  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Count day of week between dates in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Group numbers with VLOOKUP in Excel
  • Map inputs to arbitrary values in Excel
  • If cell contains one of many things in Excel
  • Categorize text with keywords in Excel

General

  • Check if range contains a value not in another range in Excel
  • Share Excel data with Word documents
  • How to calculate profit margin percentage in Excel
  • List sheet names with formula in Excel
  • 3D SUMIF for multiple worksheets in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning