# Thread: Choosing multiplying a number selected from a table

1. ## Choosing multiplying a number selected from a table

I am trying to set a rating of 1-3 using a table. The multiply this rating to deduct or add a balance based on the rating to come up with a total paid. This work on only one of the numbers in the table.

=SUM(R5*Y4,CHOOSE(T5,"1","2","3"))

The formula returns (848) but if I change it to a 2, it errors. I have a whole department with a rating of 1,2 or 3.

R1
 Total Comp S1 EXTRAS/ T1 MBP Rating U1 TOTAL DEDUCTS PAID \$ 1,702 \$ (848) 3 \$ 754

X1
 Rate Y1 Bonus% 1 (0.50) 2 1.00 3 0.25

2. Please post a sample sheet. Thx

3. ## File

Originally Posted by Pecoflyer
Please post a sample sheet. Thx
Trying to calculate T with a changing number in U from table A7:B11

4. Hello
Your upload is not helping, because you have an invalid formula in cell M4 because it has a recursive error. In this instance, you are using M4 itself as part of the calculation of M4 which means that a final result cannot be determined. You can enable recursive calcuilating, and this might be responsible for the problems your having. Can you post the correct formula that should be in M4?

5. New file. The only formula I need is in T4

6. Originally Posted by mkellycole
The only formula I need is in T4
Try
Code:
`=S4*VLOOKUP(\$U\$4;\$A\$9:\$B\$11;2;FALSE)`

7. This is not working. It is returning an error.

8. Originally Posted by mkellycole
This is not working. It is returning an error.
You may need to use a comma instead of a semicolon

9. Here is what I am trying to do:

Open the formula Problem Sheet.

I want to put take the number used in D5 (1-3), Look up the table in H4:h6, select the value the number represents in i4:i6 (-.5, 1 or .25), multiply what it returns by B5 to get a reduction or increase in the value in B5 and put the result in C5 (REF#).

10. Try =B5*(1-VLOOKUP(\$D\$5,\$H\$4:\$I\$6,2,0)/100)

Page 1 of 2 1 2 Last

#### Posting Permissions

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