If a cell is greater than or equal to a specific value

Cell Reference to Test:

Greater than or equal to this specific value:

Value if greater 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.

Value if less 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.

Formula:

=IF(C8>=$C$5,"No","Yes")