IF Partial Fuzzy Match then Calculate Percentage

I know I've done this b4 but can't recall how -- and hv tried multiple variations today that don't work (to include these, ones with VLOOKUP, IFSUM, MATCH, etc)
=IF(B18="*PAYROLL*",C18*10%,"")
=IF(B18="PAYROLL*",C18*10%,"")
=IF(B21="*PAYROLL*",C21*10%)

THIS ONE WORKS GREAT FOR AN EXACT MATCH: (but need to be able to use partial text phrases and have it calc if match)
=IF(B18="ACCOUNTING/PAYROLL",C18*10%,"")

B18 holds the text
C18 holds the $dollar amount
D18 holds the function that should show the percentage result (if no partial match, then leave cell blank)

Formula:

Please Login or Register  to view this content.

Fantastic! Thank you for the help --
I think this is what I needed:
=IF(OR(ISERROR(FIND("PAYROLL",B18))),"",C18*10%)

So if the text of COL B was:
1 ACCOUNTING/PAYROLL
2 SHIPPING DEPT PAYROLL
3 PARTS DEPT STOCK
4 PARTS DEPT PAYROLL
5 AIRPLANE PARTS
6 AIRPLANE REPAIR PERSONNEL'S PAYROLL

Then, only the cells with the word "PAYROLL" (1,2,4,6) would generate a percentage calculate within COL C

I think the one you posted was to find 2 criteria at the same time (both the words ACCOUNTING and PAYROLL) right?

Originally Posted by CHRISOK

Fantastic! Thank you for the help --
I think this is what I needed:
=IF(OR(ISERROR(FIND("PAYROLL",B18))),"",C18*10%)

So if the text of COL B was:
1 ACCOUNTING/PAYROLL
2 SHIPPING DEPT PAYROLL
3 PARTS DEPT STOCK
4 PARTS DEPT PAYROLL
5 AIRPLANE PARTS
6 AIRPLANE REPAIR PERSONNEL'S PAYROLL

Then, only the cells with the word "PAYROLL" (1,2,4,6) would generate a percentage calculate within COL C

I think the one you posted was to find 2 criteria at the same time (both the words ACCOUNTING and PAYROLL) right?

Correct. You can even simplify it to:

Formula:

Please Login or Register  to view this content.

(You don't need the OR if you only have one thing to check)

Thanks! That's exactly what I needed --- but happy to have learned 3 variations!
This will be extremely useful!
5 stars for your reputation! Thx, C.