Need help with multiplying a qualifying value by a fixed number!

1. Need help with multiplying a qualifying value by a fixed number!

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!

2. Re: Need help with multiplying a qualifying value by a fixed number!

Welcome to the forum.

Please attach the workbook - instructions at the top of the page.

3. Re: Need help with multiplying a qualifying value by a fixed number!

Thank you for the correction. Attached is the test sample I had previously in screenshot format.

4. Re: Need help with multiplying a qualifying value by a fixed number!

is this what you want? =IF(H10="life",P10*2.4,"") dragged down.

5. Re: Need help with multiplying a qualifying value by a fixed number!

Hi Sambo,

Thanks for the response. It looks like I'm getting an error somewhere when I do that. I get the #VALUE! error. I also tried, =IF(H10:I43, "LIFE", P10:Q43*2.4, "") , =IF(H10:I43,"LIFE",P10:Q43*2.4,"") , =IF(H10:I43, "LIFE", P10:Q43*2.4).

All give me the #VALUE! error.

6. Re: Need help with multiplying a qualifying value by a fixed number!

first, I just noticed this but you are using merged cells, it is best to never use merged cells.
second, are you looking to do this for a column or a single cell row by row? If for a column then I'd use =SUMIF(H10:H23,"life",P10:P23)*2.4
One problem in what you wrote in post #5 is that you have ranges in your formulas H10:I43 when if you click on "life" in row 10 and look at the cell address at the top of the workbook across from the formula line you will see it says you are actually in H10, not I10.
But my formula will give you a row by row total. Paste it for example in U10 and it will return 48 (20 in P10 times 2.4).

7. Re: Need help with multiplying a qualifying value by a fixed number!

attached is your workbook with the formulas in it. Sheet1 is what you had and in cells R10 and R11 is the row by row formula with the formula I gave you. In U10 is the sumif formula I gave you.

I also added another tab with fewer merged cells to show you how it could be done without all the merged cells and both formulas.

8. Re: Need help with multiplying a qualifying value by a fixed number!

That worked! Thank you!

9. Re: Need help with multiplying a qualifying value by a fixed number!

Glad that worked for you, AND thank you for the rep!

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1