IF function between a range of numbers e.g 1000 to 2000

Posted to microsoft.public.excel.worksheet.functions

Suz

external usenet poster

Posts: 21

IF function between a range of numbers e.g 1000 to 2000

I want to check if a number is ina range between 1000 and 2000 and I can't
get the IF function to work propoerly using the greater than and smaller than
signs

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
Passing a range name as an argument to the Index Function	Michael Sharpe	Excel Discussion (Misc queries)	3	September 5th 12 01:33 PM
Searching a range of numbers for a specified total	saustin	Excel Worksheet Functions	2	January 19th 06 03:59 PM
Row Sequencing	Mark	Excel Worksheet Functions	8	August 18th 05 06:33 PM
Count comma separated numbers, numbers in a range with dash, not t	Mahendra	Excel Discussion (Misc queries)	0	August 8th 05 05:56 PM
Excel option to store trendline's coefficients in cells for use	Miguel Saldana	Charts and Charting in Excel	9	June 20th 05 08:45 PM

All times are GMT +1. The time now is 04:40 AM.

Menu

About Us