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?
=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?