Finding closest value within an array
The thing is that I want to have static data tables then a
macro to work out grades when called upon, not calculate
them then display them. The reason for this is that these
are provisional results and are likely to be a state of
flux, so if I can just dump the data in then run a macro
that is the better solution.
Is there anyway of creating an array then looking up the
value against the array in a similar way that the match
function works?
e.g. the array would be (90,80,70) the value to look up
would be 76 and you'd want it to return 70 as it is above
70 but less than 80.
Stewart
|