I am trying to calculate unique commission rates for individual sales reps. Can I do this by creating formulas with If conditions?

You cannot create Formulas within If conditions. To calculate unique commission rates for individual sales reps, add on user input script to the Sales Rep field, and calculate the commission based on the sales rep selected. In the following sample code, Commission is a numeric field in the form. You can access the application from the following link:

http://creator.zoho.com/sampleapps/commission/form/218

Sales_Rep
 (
 displayname = "Sales Rep"
 type = text
 on user input
 {
 if ((input.Sales_Rep == "AA") || (input.Sales_Rep == "BB"))
 {
 input.Commission = (input.Sold * 0.3 - (input.Sold - input.Retail));
 }
 else
 {
 input.Commission = (input.Sold * 0.2 - (input.Sold - input.Retail));
 }
 }
 )

Related Links