Brian Cornejo

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 03:44 PM
Conditional formatting not available in Excel	BAB	Excel Discussion (Misc queries)	2	January 1st 05 03:33 PM
Count and Sum with Conditional Formatting Problem	pmahajan	Excel Worksheet Functions	1	December 14th 04 05:30 AM
Problem with Conditional format deletion	[email protected]	Excel Discussion (Misc queries)	3	December 13th 04 05:10 PM
help please with conditional format problem	Graham Warren	Excel Worksheet Functions	1	November 7th 04 05:57 PM

All times are GMT +1. The time now is 08:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us