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.