If a cell is blank in a range

Range Reference:

Value if blank:
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 around the numeric value of the cell reference.

Value if not blank:
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 around the numeric value of the cell reference.

Formula:

=IF(COUNTBLANK(C5:E5)>0,"Need Stock","Stocked")