using "isnumber(search" for a range of numbers

Hello,
I'm trying to figure out how to write a formula that will recognize the numbers 35-55 in a cell that contains other numbers and letters. If it has the numbers 35-55 then it needs to set the current cell value to zero (by multipling it by zero). I know if you want excel to locate a single number or text you use isnumber(search("text",cell range to look in), but is there a way to tell it to look for a range of numbers within a cell of text and numbers? The only way I could think to do it was by nesting the searches for each numbers using the OR command, but it keeps giving an error message, maybe because it's too many nests.

=value*IF(OR(ISNUMBER(SEARCH(35,RANGE)),(ISNUMBER(SEARCH(36,RANGE)),(ISNUMBER(SEARCH(37,RANGE)),(ISNUMBER(SEARCH(38,RANGE)),(ISNUMBER(SEARCH(39,RANGE)),(ISNUMBER(SEARCH(40,RANGE)),(ISNUMBER(SEARCH(41,RANGE)),(ISNUMBER(SEARCH(42,RANGE)),(ISNUMBER(SEARCH(43,RANGE)),(ISNUMBER(SEARCH(44,RANGE)),(ISNUMBER(SEARCH(45,RANGE)),(ISNUMBER(SEARCH(46,RANGE)),(ISNUMBER(SEARCH(47,RANGE)),(ISNUMBER(SEARCH(48,RANGE)),(ISNUMBER(SEARCH(49,RANGE)),(ISNUMBER(SEARCH(50,RANGE)),(ISNUMBER(SEARCH(51,RANGE)),(ISNUMBER(SEARCH(52,RANGE)),(ISNUMBER(SEARCH(53,RANGE)),(ISNUMBER(SEARCH(54,RANGE)),(ISNUMBER(SEARCH(55,RANGE))))))))))))))))))))))),0,1)

Thanks in advance

Thank you for the tip. I'll have to download that, unfortunately I don't know C++ at the moment. I did find a way to do it in excel though. For some reason the OR command would only let me nest two isnumber(search commands at a time, even though it's supposed to do 30. I got it to work by just doing two at a time though. Here was the end formula.

=value*IF(OR(ISNUMBER(SEARCH(35,RANGE)),(ISNUMBER(SEARCH(36,RANGE)))),0,1)*IF(OR(ISNUMBER(SEARCH(37,RANGE)),(ISNUMBER(SEARCH(38,RANGE)))),0,1)*IF(OR(ISNUMBER(SEARCH(39,RANGE)),(ISNUMBER(SEARCH(40,RANGE)))),0,1)*IF(OR(ISNUMBER(SEARCH(41,RANGE)),(ISNUMBER(SEARCH(42,RANGE)))),0,1)*IF(OR(ISNUMBER(SEARCH(43,RANGE)),(ISNUMBER(SEARCH(44,RANGE)))),0,1)*IF(OR(ISNUMBER(SEARCH(45,RANGE)),(ISNUMBER(SEARCH(46,RANGE)))),0,1)*IF(OR(ISNUMBER(SEARCH(47,RANGE)),(ISNUMBER(SEARCH(48,RANGE)))),0,1)*IF(OR(ISNUMBER(SEARCH(49,RANGE)),(ISNUMBER(SEARCH(50,RANGE)))),0,1)*IF(OR(ISNUMBER(SEARCH(51,RANGE)),(ISNUMBER(SEARCH(52,RANGE)))),0,1)*IF(OR(ISNUMBER(SEARCH(53,RANGE)),(ISNUMBER(SEARCH(54,RANGE)))),0,1)*IF(ISNUMBER(SEARCH(55,RANGE)),0,1)

Another way,

Please Login or Register  to view this content.

Hope this helps,
windknife

Wow, both your guy's methods are way easier. Thanks. Quick question, I've never used {} in a formula, what's it do that () don't? Thanks again