Nested IF function works well in one sheet but not in another

Hi and welcome to the forum

While a 37-deep nested IF() statement may sound impressive and "look" good, you have just discovered why going more than about 4-5 deep with nested F()'s is impractical - they become a complete nightmare to trouble-shoot. Besides there are far simpler methods of doing what (I think) you want to do.

If you (already have?) create a table with all the letters and the relative values, you can use a vlookup() formula instead of that monster.

Play around with vlookup() and if you still have a problem, post a sample workbook (no sensitiove data), showing what you are working with, what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.