Forum Discussion
Solved
Formula Help
I'm having difficulties figuring out a formula. I thought I'd figured it out but then it didn't work and so I am at a loss. I've attached a modified copy of the spreadsheet I've been using. Wha...
=IF(AND(LEN(B5)>=1,LEN(B5)<=6),"Walmart",IF(AND(LEN(B5)>=7,LEN(B5)<=8),"Safeway",""))
Is this the formula you are looking for?
Formula in E2:
=IFS(B5="","",LEN(B5)<=6,"Walmart",LEN(B5)>6,"Safeway")
Change the formula in the conditional formatting rule for E2 to
=E2=""