smith1370Copper ContributorSep 21, 2021Formula 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 cell...Show More
Riny_van_EekelenPlatinum ContributorSep 21, 2021smith1370 In J2 use:=I2*(10%+(B2="Homeowners")*5%)and fill down.
