Round if equal to

This tutorial shows how to round a number if it is equal to a specific number using an Excel formula, with the IF and ROUND functions

EXCEL FORMULA 1. Round if equal to

EXCEL

Hard coded formula
Round if equal to
Cell reference formula
Round if equal to
=IF(5.75=4.2,ROUND(5.75,0),5.75)
=IF(B7=$C$4,ROUND(B7,0),B7)
GENERIC FORMULA

=IF(value=equal_value,ROUND(value,0),value)

ARGUMENTS
value: The value that you want to round if it's equal to a specific value.
equal_value: The equal to number.

GENERIC FORMULA

=IF(value=equal_value,ROUND(value,0),value)

ARGUMENTS
value: The value that you want to round if it's equal to a specific value.
equal_value: The equal to number.

EXPLANATION

This formula uses the IF function to check if the value that is to be rounded is equal to a specific number. If the IF function returns a TRUE value, meaning that the number that is being tested is equal to a specific number, the formula will round the number through the use of the ROUND function. If the number does not 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 equal to value directly entered into the formula or referenced to a specific cell.

RELATED TOPICS

Related Topic Description Related Topic and Description
How to round a number if greater than a specific number
How to round a number if it is less than a specific number
How to round a number

RELATED FUNCTIONS

Related Functions Description Related Functions and Description
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
The Excel ROUND function returns a rounded number in accordance with the specified number of digits