Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to name some value. The value comes out as 1, 2, 3. I want to rename it to drop ship, warehouse order etc.
It does not seem to work.
=if(OrderType='1', Warehouse order,
if(OrderType='2', Direct Ship order,OrderType))
Attachment included.
Have you tried enclosing the text in single quotes? e.g.
=if(OrderType='1', 'Warehouse order',
if(OrderType='2', 'Direct Ship order',OrderType))
That was it. So simple.
Thank you!!!!!!
Ok, no problem. Could you please mark the reply as correct so that others don't try to answer this?