What formula to change cell using IF(AND(

Im trying to create a formula that changes my status (Ref. Only) column to "test" if true and "ok" if false; When true means that reorder point is >= On Hand QTY AND Status column is blank…

is this possible?

Best Answer

Answers