Hello!
As the title states, I am trying to learn a formula for a tracker I have built for sales. I have one column that has a drop-down selection. For any row that his this drop-down labeled as "Life," I'd like to multiply the dollar amount by a fixed number (in this case, 2.4).
I have attached the portion of the sheet that I am dealing with. As you can see, Life has been selected in the drop-down (Type of Policy), and the Premium amount is filled in with an example dollar amount. The "Points Total" column should read '48' for the first (20*2.4), and 67.20 for the second (28*2.4).
Thank you for all your help!
Bookmarks