If / And / Find Formula Help

Topic Labels: Formulas
664 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I need to generate a lead time result based on the contents of a product description {Item Name}. Any help here would be much appreciated.

If find “Spider” in {Item Name} result = 30
If find “Raw” in {Item Name} result = 3
If do NOT find “Raw” or “Spider” in {Item Name} result = 7

I tried the formula below, using all the colors in the descriptions to try to isolate the result, but it sums up the results. ie. “730”.

IF(FIND(“Raw”, {Item Name}), 3) & IF(FIND(“Black”, {Item Name}), 7) & IF(FIND(“White”, {Item Name}), 7) & IF(FIND(“Clear”, {Item Name}), 7) & IF(FIND(“Turquoise”, {Item Name}), 7) & IF(FIND(“Spider”, {Item Name}), 30)

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

Hi Matt. Give this a try…

IF(FIND(‘Spider’,{Item Name}),30,IF(FIND(‘Raw’,{Item Name}),3,7))

Good luck.