Excel Formula assistance

[mauddib13]

I need to create a formula or something that will calculate multipl
fields...

Ex: (H4) has value of points
(J2) has player level

- based on player level you can get 3 different items at lower cos

Level 1 - 3: Item 1(30); Item 2(240); item 3(600)
Level 4 - 6: Item 1(20); Item 2(232); item 3(580) ect....
These are also in the excel sheet but not sure if it easier just t
create something to calculate or refer to the lines.

Then I want (I4) - (K4) to calculate the value of (J2) grab the cos
from the item list depending on level, and divide it by (H4) total valu
of points. Which will tell me how many of each item I can purchase if
spent total points on that one item

 

[Ron Rosenfeld]

I need to create a formula or something that will calculate multiple
fields...

Ex: (H4) has value of points
(J2) has player level

- based on player level you can get 3 different items at lower cost

Level 1 - 3: Item 1(30); Item 2(240); item 3(600)
Level 4 - 6: Item 1(20); Item 2(232); item 3(580) ect....
These are also in the excel sheet but not sure if it easier just to
create something to calculate or refer to the lines.

Then I want (I4) - (K4) to calculate the value of (J2) grab the cost
from the item list depending on level, and divide it by (H4) total value
of points. Which will tell me how many of each item I can purchase if I
spent total points on that one item.

I guess that I4, J4, and K4 refer to Item1, Item2, and Item3

1. Set up a table someplace with the cost per level, e.g. $N$1:$Q$3


Level Item1 Item2 Item3
1 30 240 600
4 20 232 580


I4: =INT($H$4/VLOOKUP($J$2,$N$1:$Q$3,COLUMNS($A:B)))

copy/drag across to K4

Note that the COLUMNS(...) function will return 2 initially, and then increase
by one for each column you fill across. This will select the appropriate
column in your item cost table to use.


--ron