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

Data Analysis

  • How to create Checklist in Excel
  • Managing Conditional Formatting Rules in Excel
  • Get column name from index in Excel Table
  • How To Remove Duplicates In Excel Column Or Row?
  • How To Compare Two Lists in Excel

References

  • Two-way lookup with VLOOKUP in Excel
  • How to get last row in numeric data in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to get first row number in range in Excel
  • How to get last column number in range in Excel

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation date in next 30 days
  • Excel Data validation must contain specific text
  • Excel Data validation date in specific year
  • Excel Data validation require unique number

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 cells that fall below a given value, which is hardcoded as 65 in the formula:

COUNTIF(B5:F5,"<65")

In this part of the formula, COUNTIF will return a positive number if any cell in the range is less than 65, and zero if not. In the range B5:F5, there is one score below 65 so COUNTIF will return 1.

The NOT function is used to convert the number of from COUNTIF into a TRUE or FALSE result. The trick is that NOT also “flips” the result at the same time:

  • If any values are less than 65, COUNTIF returns a positive number and NOT returns FALSE
  • f no values are less than 65, COUNTIF returns a zero and NOT returns TRUE

This is the equivalent of wrapping COUNTIF inside IF and providing a “reversed” TRUE and FALSE result like this:

=IF(COUNTIF(B5:F5,"<65"),FALSE,TRUE)

Post navigation

Previous Post:

How to calculate project complete percentage in Excel

Next Post:

Popularly Used Excel Functions and their examples

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRUE Function
  • Not Equal To ‘<>‘ operator in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Custom weekday abbreviation in Excel
  • Calculate series of dates by workdays in Excel
  • Convert Unix time stamp to Excel date
  • How to calculate Quarter of Date in Excel
  • Get first day of month in Excel

Grouping

  • How to randomly assign people to groups in Excel
  • Calculate conditional mode with criteria in Excel
  • Map text to numbers in Excel
  • Group numbers with VLOOKUP in Excel
  • Categorize text with keywords in Excel

General

  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • How to get Excel workbook path only
  • 44 Practical Excel IF function Examples
  • How to count total columns in range in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning