Posted to microsoft.public.excel.newusers

Quimera

external usenet poster

Posts: 24

IF formula for a number range specification

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
How can I use a formula to return the first number in a range?	Husker87	Excel Worksheet Functions	14	June 16th 09 03:26 AM
INCORPORATING A ROW NUMBER INTO A FORMULA RANGE	Morton Detwyler[_2_]	Excel Worksheet Functions	0	December 2nd 08 09:18 PM
HELP!I need a specification template purchasing Interior Design it	designer	Excel Worksheet Functions	1	July 6th 05 04:47 PM
vlookup file specification	h2olawrence	Excel Worksheet Functions	3	May 8th 05 05:39 PM
Summing all rows with certain specification	martin	Excel Worksheet Functions	2	January 7th 05 01:43 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us