I am trying to figure out a formual in Crystal reports that will do the following. I have a commission report set up for salespeople. I have the report grouped by salesperson. The report basically shows the salesperson, what sales are eligble for commission, the sale amount and the commission pay amount. I want to add a bonus to the commission pay if the salesperson sales exceed a specific number. The issue is i want that sales amount and bonus amount to be diffrent for each salesperson. The below works but i need to be able to add other if then statements to the formual to account for diffrent sales and bounus numbers.
if (salesperson)='johndoe' and (salesamount)>100000 then (compay)+500 else compay
How would i fix this to add 'janedoe' when her sales go over 150000 she gets a 1000 bonus?