I wrote this formula on excel to return specific values based on the conditions inputted. However, after writing the formula on google sheets it doesn’t seem to work as it does on excel. It only takes the first condition such as “1”, “LR0”, “C”, etc… but doesn’t read the other “criteria”… Does anybody know why it does not work?

=IF(OR(LEFT(B3,3)={“LR0″,”R90″,”R91″,”PW0″})*AND(LEN(B3)={8}),”Lenovo ThinkPad Yoga Series”,””)&
IF(OR(LEFT(B3,1)={“1″,”2″,”3″,”4″,”5″,”6″,”7″,”8″,”9″,”B”,”C”,”D”,”F”,”G”,”H”,”J”})*AND(LEN(B3)<{8}),”Dell Latitude 3100 Series”,””)&
IF(OR(LEFT(B3,1)={“C”,”D”,”F”,”G”,”H”,”J”,”K”,”L”,”M”,”N”,”P”,”Q”,”R”,”S”,”T”,”V”,”W”,”X”,”Y”,”Z”})*AND(LEN(B3)>={9}),”Apple iPad”,””)&IF(OR(LEFT(B3,3)={“5CG”,”5DB”})*AND(LEN(B3)={10}),”HP X360 11 EE”,””)

Tried editing the formula based on some information that I found searching on google. I’m not very proficient on google sheets.