Excel 2008 : numbers in range

[Teo]

hi,

i need a formula which gives me FALSE or TRUE, or any other notification if number is in between or equal in specific range.
result has to be similar like one on the picture, with no errors in cells which are out of range.

thanks

\1

[Richard Buttrey]

Hi and welcome to the forum.

Please don't post pictures of worksheets - or anything else for that matter. Post the workbook itself and you'll get more response.
None of us are keen to type all your data into a worksheet just to get to the starting gate.

Rgds

[Teo]

Hi and welcome to the forum.

Please don't post pictures of worksheets - or anything else for that matter. Post the workbook itself and you'll get more response.
None of us are keen to type all your data into a worksheet just to get to the starting gate.

Rgds

thank you and sorry ... first post has attached file now ...

[Richard Buttrey]

Hi,

It's probably easier if you list the missing numbers - see column D in the attached. If there are a lot of From..To ranges in a real world situation then you could get a macro t do that first. Then use the formulae you see in column G.

HTH

[Teo]

problem is that i do not know missing numbers ... in real application i need to make FROM-TO are dates. DATE FROM and DATE TO are not all the time the same. And i need to list all the dates in range. Dates in excel (and others applications) are actually numbers so that is the reason i give this example.
maybe some function to find the missing numbers first and then use solution you make. and also i see that numbers from 30 to 33 are marked as YES, but they are out of range.

//edit: i don't need list of dates, i just need to know are they in range.

[Teo]

Finally i found a solution. All credits goes to mr. Andrew P. Don't know if he is a member of this forum, but he found solution in no time .

If somebody needs something similar here is solution attached.
Thank you all who tried.