I work for a plumbing company and I take care of payroll. We pay our technicians commission on some of their jobs and I want to create a formula within Excel to take care of this. We pay the commission the same week if its residential work (since we get paid upon completion). Is there a way I can create a formula to work that is A1 has an "R" in it, it will take the amount is B1 and multiply it by the percentage I have in C1? I have tried different =IF functions and keep coming up with issues.

Thanks for the help! I'm not very computer savvy--I went to culinary school.