Hello everyone and thank you in advance.
Mainly I'm trying to have my spreedsheet return a value in a single cell based off of a range of data.
what i want is to place a perctage value in cell A2 and have the spreedsheet compaire this to the date in the below table then place the corresponding number in cell A1
Example = if i place 92.75% in cell A2 cell A1 is populated with a 3
Example below
Cell to return number = A1
Cell with Data to compaire to table = A2
Data in 3 collums
5 100.00% 100.00%
4.75 99.99% 99.00%
4.5 98.99% 98.00%
4.25 97.99% 97.00%
4 96.99% 96.00%
3.75 95.99% 95.00%
3.5 94.99% 94.00%
3.25 93.99% 93.00%
3 92.99% 90.00%
2.75 89.99% 89.00%
2.5 88.99% 88.00%
2.25 87.99% 87.00%
2 86.99% 86.00%
1.75 85.99% 85.00%
1.5 84.99% 84.00%
1.25 83.99% 83.00%
1 82.99% 0.00%
Any thoughts? thanks
Bookmarks