Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Brian Cornejo
 
Posts: n/a
Default problem with a conditional max problem


-- 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
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

If your tabulated x's are in a range named "tabx", one way:


=f(LOOKUP(E12,tabx))

where f() is your function.

In article ,
"Brian Cornejo" wrote:

-- 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting problem Cumbo Excel Discussion (Misc queries) 2 January 5th 05 04:44 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 04:33 PM
Count and Sum with Conditional Formatting Problem pmahajan Excel Worksheet Functions 1 December 14th 04 06:30 AM
Problem with Conditional format deletion [email protected] Excel Discussion (Misc queries) 3 December 13th 04 06:10 PM
help please with conditional format problem Graham Warren Excel Worksheet Functions 1 November 7th 04 06:57 PM


All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"