- Joined
- Jul 30, 2008
- Messages
- 11
- Reaction score
- 0
I have created a table that will give me the FLOOR value of number that constantly varies.
For example if the number is 62 and the formula for the for the floor is =FLOOR(62,18) the solution is 54. My table starts at 18 as the significance and descends by .5 down to 3. What I want to do is create a formula that will pick and put the significance in one cell based on a criteria that is user entered in another cell 12 (being the significance) or less and the difference between the result from that column (in the table) divided by 2 in the next column. Like this perhaps. I have a possible of 50 rows (same column) which will likely all have several different numbers.
Column A Column B
11.5 =(62-57.5)/2 which equals 2.25
My biggest problems are:
1) my table is limited to the ability of .5 increments.
2) my result from column B can't be less than 1.25 or greater than 2.5
This gives me a very narrow window to work with but it is a must.
I tried this on a smaller version but I get #n/a as the result. O15 is the significance.
=INDEX(Q16:AA26,MATCH(O15,Q16:AA26,0),1)
PLEASE HELP ME IM LOST
Thank You,
scottgorilla
For example if the number is 62 and the formula for the for the floor is =FLOOR(62,18) the solution is 54. My table starts at 18 as the significance and descends by .5 down to 3. What I want to do is create a formula that will pick and put the significance in one cell based on a criteria that is user entered in another cell 12 (being the significance) or less and the difference between the result from that column (in the table) divided by 2 in the next column. Like this perhaps. I have a possible of 50 rows (same column) which will likely all have several different numbers.
Column A Column B
11.5 =(62-57.5)/2 which equals 2.25
My biggest problems are:
1) my table is limited to the ability of .5 increments.
2) my result from column B can't be less than 1.25 or greater than 2.5
This gives me a very narrow window to work with but it is a must.
I tried this on a smaller version but I get #n/a as the result. O15 is the significance.
=INDEX(Q16:AA26,MATCH(O15,Q16:AA26,0),1)
PLEASE HELP ME IM LOST
Thank You,
scottgorilla