problem with a conditional max problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

-- What formula could you enter in cell E13 so that if a value is entered
in cell E12, cell E13 will display the value of f(x) that corresponds to the
largest tabulated x which is less than or equal to the value entered. For
example, if 3 is entered in cell E12, then E13 should display the value of
f(0).
Brian
 
If your tabulated x's are in a range named "tabx", one way:


=f(LOOKUP(E12,tabx))

where f() is your function.
 
Back
Top