Nested If function

%3CLINGO-SUB%20id%3D%22lingo-sub-2765676%22%20slang%3D%22en-US%22%3ENested%20If%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2765676%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%20I%20am%20in%20desperate%20need%20of%20help.%20I%20am%20pulling%20my%20hair%20out.%20I%20am%20trying%20to%20do%20a%20nested%20If%20statement%20with%2049%20if%20statements%20from%20a%20pull%20down%20list%20and%20at%20the%20end%20it%20says%20I%20am%20missing%20parenthesis.%20When%20I%20add%20them%20it%20says%20too%20many.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2765691%22%20slang%3D%22en-US%22%3ERe%3A%20Nested%20If%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2765691%22%20slang%3D%22en-US%22%3E%3DIF(G4%3DSheet2!A2%2CJ8*56.901%2CIF(G4%3DSheet2!A3%2CJ8*61.316%2CIF(G4%3DSheet2!A4%2CJ8*67.448%2CIF(G4%3DSheet2!A5%2CJ8*85.842%2CIF(G4%3DSheet2!A6%2CJ8*91.973%2CIF(G4%3DSheet2!A7%2CJ8*98.105%2CIF(G4%3DSheet2!A8%2CJ8*122.632%2CIF(G4%3DSheet2!A10%2CJ8*147.158%2CIF(G4%3DSheet2!A11%2CJ8*153.289%2CIF(G4%3DSheet2!A13%2CJ8*183.949%2CIF(G4%3DSheet2!A14%2CJ8*187.013%2CIF(G4%3DSheet2!A15%2CJ8*196.211%2CIF(G4%3DSheet2!A16%2CJ8*202.343%2C%2CIF(G4%3DSheet2!A17%2CJ8*208.474%2CIF(G4%3DSheet2!A18%2CJ8*233.000%2CIF(G4%3DSheet2!A19%2CJ8*245.265%2CIF(G4%3DSheet2!A20%2CJ8*282.053%2CIF(G4%3DSheet2!A21%2CJ8*294.316%2CIF(G4%3DSheet2!A22%2CJ8*374.029%2CIF(G4%3DSheet2!A23%2CJ8*392.423%2CIF(G4%3DSheet2!A24%2CJ8*42.185%2CIF(G4%3DSheet2!A25%2CJ8*52.732%2CIF(G4%3DSheet2!A26%2CJ8*84.370%2CIF(G4%3DSheet2!A27%2CJ8*105.464%2CIF(G4%3DSheet2!A28%2CJ8*126.557%2CIF(G4%3DSheet2!A29%2CJ8*158%2C195%2CIF(G4%3DSheet2!A30%2CJ8*168.742%2CIF(G4%3DSheet2!A31%2CJ8*263.659%2CIF(G4%3DSheet2!A32%2CJ8*28.697%2CIF(G4%3DSheet2!A33%2CJ8*57.391%2CIF(G4%3DSheet2!A34%2CJ8*71.740%2CIF(G4%3DSheet2!A35%2CJ8*111.962%2CIF(G4%3DSheet2!A36%2CJ8*152.678%2CIF(G4%3DSheet2!A37%2CJ8*178.123%2CIF(G4%3DSheet2!A38%2CJ8*103.011%2CIF(G4%3DSheet2!A39%2CJ8*190.324%2CIF(G4%3DSheet2!A40%2CJ8*93.812%2CIF(G4%3DSheet2!A41%2CJ8*187.627%2CIF(G4%3DSheet2!A44%2CJ8*156.356%2CIF(G4%3DSheet2!A45%2CJ8*166.780%2CIF(G4%3DSheet2!A46%2CJ8*208.474%2CIF(G4%3DSheet2!A47%2CJ8*234.533%2CIF(G4%3DSheet2!A48%2CJ8*239.745%2CIF(G4%3DSheet2!A49%2CJ8*250.169%2CIF(G4%3DSheet2!A50%2CJ8*317.924%2CIF(G4%3DSheet2!A51%2CJ8*56.901%2CIF(G4%3DSheet2!A52%2CJ8*98.105%2CIF(G4%3DSheet2!A53%2CJ8*202.343%2CIF(G4%3DSheet2!A54%2CJ8*245.265%2C)%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi everyone I am in desperate need of help. I am pulling my hair out. I am trying to do a nested If statement with 49 if statements from a pull down list and at the end it says I am missing parenthesis. When I add them it says too many.

 

2 Replies
=IF(G4=Sheet2!A2,J8*56.901,IF(G4=Sheet2!A3,J8*61.316,IF(G4=Sheet2!A4,J8*67.448,IF(G4=Sheet2!A5,J8*85.842,IF(G4=Sheet2!A6,J8*91.973,IF(G4=Sheet2!A7,J8*98.105,IF(G4=Sheet2!A8,J8*122.632,IF(G4=Sheet2!A10,J8*147.158,IF(G4=Sheet2!A11,J8*153.289,IF(G4=Sheet2!A13,J8*183.949,IF(G4=Sheet2!A14,J8*187.013,IF(G4=Sheet2!A15,J8*196.211,IF(G4=Sheet2!A16,J8*202.343,,IF(G4=Sheet2!A17,J8*208.474,IF(G4=Sheet2!A18,J8*233.000,IF(G4=Sheet2!A19,J8*245.265,IF(G4=Sheet2!A20,J8*282.053,IF(G4=Sheet2!A21,J8*294.316,IF(G4=Sheet2!A22,J8*374.029,IF(G4=Sheet2!A23,J8*392.423,IF(G4=Sheet2!A24,J8*42.185,IF(G4=Sheet2!A25,J8*52.732,IF(G4=Sheet2!A26,J8*84.370,IF(G4=Sheet2!A27,J8*105.464,IF(G4=Sheet2!A28,J8*126.557,IF(G4=Sheet2!A29,J8*158,195,IF(G4=Sheet2!A30,J8*168.742,IF(G4=Sheet2!A31,J8*263.659,IF(G4=Sheet2!A32,J8*28.697,IF(G4=Sheet2!A33,J8*57.391,IF(G4=Sheet2!A34,J8*71.740,IF(G4=Sheet2!A35,J8*111.962,IF(G4=Sheet2!A36,J8*152.678,IF(G4=Sheet2!A37,J8*178.123,IF(G4=Sheet2!A38,J8*103.011,IF(G4=Sheet2!A39,J8*190.324,IF(G4=Sheet2!A40,J8*93.812,IF(G4=Sheet2!A41,J8*187.627,IF(G4=Sheet2!A44,J8*156.356,IF(G4=Sheet2!A45,J8*166.780,IF(G4=Sheet2!A46,J8*208.474,IF(G4=Sheet2!A47,J8*234.533,IF(G4=Sheet2!A48,J8*239.745,IF(G4=Sheet2!A49,J8*250.169,IF(G4=Sheet2!A50,J8*317.924,IF(G4=Sheet2!A51,J8*56.901,IF(G4=Sheet2!A52,J8*98.105,IF(G4=Sheet2!A53,J8*202.343,IF(G4=Sheet2!A54,J8*245.265,)
You have posted on the Microsoft Learn community board which is all about exams, certification and training. I am not sure what you are using but if it is Excel, then you might get a better response on the Excel community board https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat