Struggling to have values appear as "Yes" or "no" for > or < numbers

Hey guys,

I am trying to create a stocktake sheet in which is smart enough to tell me after stocktake if I require to order items. 

I understand how to create the cells to be reactive to numbers >8 turn green and numbers <9 turn red to indicate they are getting low. I am looking to have these state "Yes" and "No" Under the Order column. Is this possible, if so could you please let me know the function/equation in which does this?

Thank you in advance!