Hello~

Im trying to create a formula based on ranges of numbers, as well as single
value numbers in a spreadsheet to where the out put is a value of either Y
(for yes) or N (for no) depending on where in the range of numbers my search
criteria falls........I was thinking an IF THEN OR statement, but cannot seem
to figure out the 'nesting' part of it correctly........ Here is an example
below:

I am looking for the below numbers, or RANGE of numbers on my spreadsheet,
and if found I need the output value to be Y......If NOT found, the value
returned needs to be N.
00000;00999
06380
06460
06510
06440
02430;02440
06400;06410
06520
06540

Not sure what to do.

Thanks-

Mary