Remember Me?

#1
January 3rd 07, 03:21 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2006 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

#2
January 3rd 07, 03:25 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 1,726
IF function between a range of numbers e.g 1000 to 2000

=IF(AND(A1=1000,A1<=2000),"yes","no")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

"suz" wrote in message
...
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

#3
January 3rd 07, 03:30 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 11,058
IF function between a range of numbers e.g 1000 to 2000

=IF(AND((A11000),(A1<2000)),"Yes","No")
--
Gary's Student

"suz" wrote:

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

#4
January 3rd 07, 03:42 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 14
IF function between a range of numbers e.g 1000 to 2000

hi,

=AND(a1=1000,a1<=2000)
result either true or false
maybe..

"suz" wrote:

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Michael Sharpe Excel Discussion (Misc queries) 3 September 5th 12 01:33 PM saustin Excel Worksheet Functions 2 January 19th 06 03:59 PM Mark Excel Worksheet Functions 8 August 18th 05 06:33 PM Mahendra Excel Discussion (Misc queries) 0 August 8th 05 05:56 PM Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM

All times are GMT +1. The time now is 11:20 AM.