I am working on my commissions spreadsheet. My commission percent is different if it's homeowners or auto, 15% for home and 10% for auto. What I would like to do is change the formulas for the cells under the J row based on the B cells. Basically if Policy type says homeowners, J2 formula would be =i2*15% and if the policy type is Auto the formula for J6 is =i6*10%. So far I have been changing the formulas manually. Is there a way to make it automatically change the formulas?
