Hi I have a spreadsheet with column c2 showing either a number or blank and I have data in w2 either being warehouse, direct supply or direct delivery, I need D2 to tell me if c2 is blank and w2 is direct supply or direct delivery "pod needed", if c2 not blank I need it to say "have pod" and if w2 is warehouse it needs to return either "have pod" if value in c2 or "warehouse investigation" if blank.
I have tried if and formula but it's not returning correctly
I have tried if and formula but it's not returning correctly