IF(ISNUMBER(SEARCH issue with double digits

Hello,
I am trying to calculate formulas and use the following code. It works great, until I try using double digits. It is only picking up the first digit. Any help would be greatly appreciated.. Thank You.

=IF(ISNUMBER(SEARCH("1",D3)),"12",
IF(ISNUMBER(SEARCH("2",D3)),"11",
IF(ISNUMBER(SEARCH("3",D3)),"10",
IF(ISNUMBER(SEARCH("4",D3)),"9",
IF(ISNUMBER(SEARCH("5",D3)),"8",
IF(ISNUMBER(SEARCH("6",D3)),"7",
IF(ISNUMBER(SEARCH("7",D3)),"6",
IF(ISNUMBER(SEARCH("8",D3)),"5",
IF(ISNUMBER(SEARCH("9",D3)),"4",
IF(ISNUMBER(SEARCH("10",D3)),"3",
IF(ISNUMBER(SEARCH("11",D3)),"2",
IF(ISNUMBER(SEARCH("12",D3)),"1"
))))))))))))

Thank you.

I tried removing all of the "" from the numbers and I am still having issues.

D3 will be numbers ranging from 1-100, with each number there is a point value associated that will appear in E3. Example: If you enter 1 in D3, it should populate 12 in E3, 2 should be 11, so on and so forth. If i enter 12 in D3, it should show 1 in E3, however it jumps back to 12.

Try this:

=13-D3

Originally Posted by martindwilson

well that's correct because the number 1 is contained in the number 12 so it matches
to make that work you need longest first

Formula:

Please Login or Register  to view this content.

but from 1-12 you could just use
=13-d3
tm the idea is to answer the op not just suggest an random answer

The formula you provided worked great!! Thank you for your help, and everyone else as well!