So what I need to do is create a formula that will help to solve an issue where I need to add I think an IF function to a array formula that I have that is looking at one value and determining if it is within a range and then giving another cell a number based on that range. The array formula that I have now works great but it is based on a max number of 32.
what i need to have now is the formula needs to be adjusted when that number is changed to 16 or 8. I know I can just adjust the formula to do that but I need it to do it automatically by changing the one cell.
I have included a doc that has what I am thinking. so A column has the list of numbers from 1-35 (ranking) the formula row B column right now has the array formula in it. what I need is when you change the yellow box to either 32 , 16 , 8 it will adjust the formula automatically to show the below info
if yellow box says 32 *** the formula already does this but not linked to the yellow box***
1-8 will be 4
9-16 it will be 2
17-32 it will be 1
less then 16 will be 0
if yellow box says 16
1-8 it will be 3
9-16 it will be 1
less then 16 will be 0
If the yellow box is 8
1-8 it will be 2
I am thinking there needs to be a IF function in there that will adjust the formula based on what is in the yellow box.
thanks
Bookmarks