If a cell is greater than a specific value
Cell Reference to Test:
|
Greater than this specific value:
|
Value if greater than a specific value:
if the value that you want returned is a text value, you will need to include the quotation marks around the value. However, if you want to return a numeric value or referencing to a cell then there is no need to include the quotation marks. |
Value if less than or equal to a specific value:
if the value that you want returned is a text value, you will need to include the quotation marks around the value. However, if you want to return a numeric value or referencing to a cell then there is no need to include the quotation marks. |
Formula:
|
=IF(C8>$C$5,"No","Yes")
=IF(C8>$C$5,"No","Yes")