Applying multiple SEARCH text options to one IF function

[Laurence D]

I am wanting to design the IF function code that will search for multiple text options and apply the same function to the cell but I am unsure how to finish the code off. Could someone please help me?


In the scenario below the IF function needs to pick up both the text "Yes" and "Maybe" and apply the commission value to the price. I can get only one text value to work using this code:

Either
=IF(IFERROR(SEARCH("Yes",A1),0)<>0,B1+(C1*B1),B1)
Or
=IF(IFERROR(SEARCH("Maybe",A1),0)<>0,B1+(C1*B1),B1)

but have not managed to get the code to accept both yes and maybe.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Commission[/TD]
[TD]Price[/TD]
[TD]Commission
value %[/TD]
[TD]If code
is working
properly[/TD]
[/TR]
[TR]
[TD]Yes[/TD]
[TD]300000[/TD]
[TD]9%[/TD]
[TD]327000[/TD]
[/TR]
[TR]
[TD]Maybe[/TD]
[TD]250000[/TD]
[TD]8%[/TD]
[TD]270000[/TD]
[/TR]
[TR]
[TD]Maybe[/TD]
[TD]200000[/TD]
[TD]7%[/TD]
[TD]214000[/TD]
[/TR]
[TR]
[TD]No[/TD]
[TD]150000[/TD]
[TD]6%[/TD]
[TD]150000[/TD]
[/TR]
[TR]
[TD]Yes
[/TD]
[TD]100000[/TD]
[TD]5%[/TD]
[TD]105000[/TD]
[/TR]
[TR]
[TD]No[/TD]
[TD]50000[/TD]
[TD]4%[/TD]
[TD]50000[/TD]
[/TR]
</tbody>[/TABLE]

Thanks

 

[iliace]

How about this?

=IF(OR(A1={"Yes","Maybe"}),B1+C1*B1,B1)