Forum Discussion

smith1370's avatar
smith1370
Copper Contributor
Sep 21, 2021

Formula Help

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?

Resources