Hi,
Not sure how to do this but I want to have a cell display various message text depending the value input into another cell
e.g. if value in cell D10 = 1 then in cell D8 I want to see the message Change
if value in cell D10 = 2 then in cell D8 I want to see the message Pump Out
I may want to expand this for several more different messages. Can this be done?
Not sure how to do this but I want to have a cell display various message text depending the value input into another cell
e.g. if value in cell D10 = 1 then in cell D8 I want to see the message Change
if value in cell D10 = 2 then in cell D8 I want to see the message Pump Out
I may want to expand this for several more different messages. Can this be done?