New to queries.

E8 = calculated value based on manually inputted data in B4
D2:D13 = contains set numerical values ranging from .00722 to .003608 from lowest to highest
B7 = query field that determines next highest value from column D based on E8. =QUERY(D2:D,"select D where D >= "&E8&" order by D limit 1",-1)

B9 = Query field that determines next lowest value from column D based on E8 not sure where to go here

Please help me solve this mystery.
Open to suggestions for both B7 and B9 if there is a better option.

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.