My =IF(ISNUMBER(SEARCH Formula is Not Working

Hello,

Can someone please help me fix my formula? For some reason it isn't working and is returning the following "#VALUE"

=IF(ISNUMBER(SEARCH("safety",O1300)),K1300*1.14,""),IF(ISNUMBER(SEARCH("tool",O1300)),K1300*1.13,""),IF(ISNUMBER(SEARCH("construction",O1300)),K1300*1.12,""),IF(ISNUMBER(SEARCH("facilit",O1300)),K1300*1.12,"")

My report is VERY long hence the big numbers. But really what i'm trying to do is that in column "O" there are seven different types of commodities. So the seven different values you will see in column "O" are:

1. Safety
2. Tools
3. CONSTRUCTION SUPPLIES
4. construction
5. FACILITIES
6. FIRST AID & SAFETY

So what im trying to say in my formula is:

If the cell in column O contains the word safety then multipy column K by 1.14 OR if column O contains the word tools then multiply column K by 1.13 or if column O contains the word construction or the word facilities then multiply column k by 1.12.

Solved! Thank you!

try this:-

Please Login or Register  to view this content.

i am facing the same issue. My formula and data is simple

I have cells with data. I am searching for "JPN_"

Data is like this

A1 usa,mexico
B1 greece,JPN_region1
C1 portugal,america

I am using this formula

=ISNUMBER(MATCH("JPN_",A1))

I am not getting TRUE for B1

Thanks
-joe