Dear reader,
I have a table looking like this:
I've got a cell to input any value next to it. I'm trying to get the result of the average column to which any Range number applies.
Formula for the input cell, which works for the first row: =IF(OR(AA5<=U9;AA5>=W9);"No Result";T9)
So if the number lies between 0 and 313 I want to get the result 0,1. If the number lies between 314 and 523 I want to get the result 0,2 and so on.
The formula works but only for the first row. I'm not sure how to get it to search each Min/Maxrange for the right result.
Any help is much appreciated, thanks!
Steve
I have a table looking like this:
Min (Q) | (R) | Max (S) | Average (T) | MinRange (U) | (V) | MaxRange (W) |
0,000 | - | 0,149 | 0,1 | 0 | - | 313 |
0,150 | - | 0,249 | 0,2 | 314 | - | 523 |
0,250 | - | 0,349 | 0,3 | 524 | - | 732 |
0,350 | - | 0,449 | 0,4 | 733 | - | 942 |
0,450 | - | 0,549 | 0,5 | 943 | - | 1151 |
I've got a cell to input any value next to it. I'm trying to get the result of the average column to which any Range number applies.
Formula for the input cell, which works for the first row: =IF(OR(AA5<=U9;AA5>=W9);"No Result";T9)
So if the number lies between 0 and 313 I want to get the result 0,1. If the number lies between 314 and 523 I want to get the result 0,2 and so on.
The formula works but only for the first row. I'm not sure how to get it to search each Min/Maxrange for the right result.
Any help is much appreciated, thanks!
Steve