LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Return a value if variable is in a range

I have a column that includes a number representing attained age. There are
approximately 21,000 records. I need to find the distribution of ages in
increments of 10. i.e., the number of records betwen 0 and 10, 11 and 20, 21
and 30, etc.

I've tried using an if statement in the following format:
=IF(11<=D2<=20,1,0). If D2 (attained age) is = 11 and is less than 20, give
me 1 as the value, otherwise, return 0. The statement does not seem to be
working properly.

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Variable Range for NPV Dkline Excel Worksheet Functions 7 August 27th 08 02:14 PM
Return a Variable value length Sean Excel Worksheet Functions 5 December 4th 06 09:25 PM
variable range John New Users to Excel 2 July 21st 06 03:42 PM
from Range variable Marina Limeira Excel Discussion (Misc queries) 0 January 22nd 06 02:35 PM
from Range variable Marina Limeira Charts and Charting in Excel 0 January 22nd 06 02:35 PM


All times are GMT +1. The time now is 08:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"