Question: how to create a formula in excel that will place the word yes?
Answer: Type "=CONCATENATE(A2,B2)" and press the ENTER Key. In cell G2, create a formula that will place the word "Yes" if cell F2 (Quantity in Stock) is less than 25% of H2 (Quantity in Reorder) or "No" if this condition is not met. Click the FORMULAS Tab, then click INSERT FUNCTION button.