Round if doesn't equal to
This tutorial shows how to round a number if it doesn't equal to a specific number using an Excel formula, with the IF and ROUND functions
Hard coded formula
Cell reference formula
|
GENERIC FORMULA
=IF(value<>doesnt_equal_value,ROUND(value,0),value)
ARGUMENTS GENERIC FORMULA
=IF(value<>doesnt_equal_value,ROUND(value,0),value)
ARGUMENTS EXPLANATION This formula uses the IF function to check if the value that is to be rounded doesn't equal to a specific number. If the IF function returns a TRUE value, meaning that the number that is being tested doesn't equal to a specific number, the formula will round the number through the use of the ROUND function. If the number is equal to the specific number the formula will return the exact number that is being tested, without rounding it.
Click on either the Hard Coded or Cell Reference button to view the formula that has the not equal to value and the number that is being tested directly entered into the formula or referenced to specific cells. |
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Round if less than or equal to | How to round a number if it is less than or equal to a specific number | |
| Round if greater than or equal to | How to round a number if it is greater than or equal to a specific number | |
| Round if greater than | How to round a number if greater than a specific number | |
| Round if less than | How to round a number if it is less than a specific number | |
| Round if equal to | How to round a number if it is equal to a specific number |
RELATED FUNCTIONS
| Related Functions | Description | Related Functions and Description |
|---|---|---|
| IF Function | The Excel IF function performs a test on specified conditions entered into the formula and returns a specified value if the result is TRUE or another specified value if the result is FALSE | |
| ROUND Function | The Excel ROUND function returns a rounded number in accordance with the specified number of digits |