Posted to microsoft.public.excel.newusers

Quimera

external usenet poster

Posts: 24

IF statement using number ranges

I need a nested IF formula that can assign a code to a range of numbers.
There are 5 ranges.

For example...If (A2=10 and <=14, "1", IF (A2=15 and
<=140,"2"),IF(......."5"),"Error"))

I don't know how to define the range.

Thank you for your always helpful help.

Rose

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 Then Statement based on ranges	Multiple If, Then statements	Excel Worksheet Functions	5	November 18th 09 07:08 PM
Count the number between age ranges	Nigel	Excel Discussion (Misc queries)	2	October 13th 08 12:20 PM
Using named ranges in AdvacendFilter statement	Laurence Lombard	Excel Discussion (Misc queries)	1	May 15th 05 01:43 PM
COUNTIF Statement with Multiple Conditions in Different Ranges	KJA	Excel Worksheet Functions	2	April 26th 05 05:14 PM
If Statement Between Ranges?	Geeoff	Excel Discussion (Misc queries)	0	February 23rd 05 03:09 PM

All times are GMT +1. The time now is 02:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us