Posted to microsoft.public.excel.worksheet.functions

JerryS

external usenet poster

Posts: 13

Multiple IF's to Select a Value

Using the following table, I want a formula that satifies multiple IF type
statements.

From To MTM Renew 10
0 30 $32.39 $17.60
31 100 $31.94 $15.35
101 225 $31.04 $14.00
226 450 $30.59 $12.20
451 1000 $29.24 $10.40

For example, if one value is greater than 101 and less than 225, the value
is $31.04.

Any ideas?

--
JerryS

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
Multiple If's and OR's	Shelly	Excel Worksheet Functions	16	February 19th 07 11:44 PM
trying to select multiple cells	marrie	New Users to Excel	7	September 11th 06 05:09 PM
Multiple "if's"	athalon	Excel Worksheet Functions	1	February 10th 06 08:02 PM
multiple IF's ?	foilprint0	Excel Worksheet Functions	1	January 31st 06 04:59 PM
Formula with multiple IF'S	Kim46770	Excel Discussion (Misc queries)	2	May 17th 05 10:31 PM

All times are GMT +1. The time now is 06:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us