nested if statement generator

%3CLINGO-SUB%20id%3D%22lingo-sub-2324153%22%20slang%3D%22en-US%22%3Enested%20if%20statement%20generator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2324153%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20excel%20gods%2C%20im%20currently%20creating%20a%20complete%20mathmatical%20excel%20spreadsheet.%20basicly%20im%20making%20a%20spreadsheet%20that%20has%20all%20fasits%20of%20math%20in%20the%20one%20spread%20sheet%20and%20ive%20finished%20this%20section%20but%20i%20notised%20an%20error%20in%20my%20nested%20if%20statement%20in%20that%20it%20is%20not%20fcompleted%20the%20reson%20i%20created%20this%20formula%20is%20to%20get%20multiple%20imputs%20for%20places%20and%20to%20use%20different%20sums%20in%20responce%20if%20a%20value%20is%20not%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20im%20in%20need%20of%20is%20a%20way%20to%20quickly%20create%20a%20nested%20if%20form%20(below%20is%20an%20example%20of%20what%20kind%20of%20thing%20im%20talking%20about)%3C%2FP%3E%3CP%3EThis%20is%20a%20simple%20intrest%20segment%20of%20my%20sheet%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel%20screen%20shot.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278122i18D2C3239B1E36F3%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel%20screen%20shot.jpg%22%20alt%3D%22excel%20screen%20shot.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBTW%20if%20you%20know%20of%20a%20way%20to%20simplifi%20this%20plz%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2324153%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2324495%22%20slang%3D%22en-US%22%3ERe%3A%20nested%20if%20statement%20generator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2324495%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1045206%22%20target%3D%22_blank%22%3E%40HomoRogue%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20looks%20to%20me%20as%20if%20you%20might%20be%20better%20served%20by%20the%20%3CSTRONG%3EIFS%3C%2FSTRONG%3E%20function%2C%20rather%20than%20a%20long%20multi-layered%20nested%20set%20of%20IF%20functions.%20Here's%20a%20good%20resource%20to%20help%20understand%20how%20the%20%3CSTRONG%3EIFS%3C%2FSTRONG%3E%20function%20works.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-ifs-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-ifs-function%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20more%20help%2C%20may%20I%20recommend%20you%20attach%20an%20actual%20copy%20of%20the%20actual%20spreadsheet--so%20long%20as%20it%20contains%20no%20confidential%20information.%20An%20image%20doesn't%20go%20very%20far%20in%20helping%20us%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Dear excel gods, im currently creating a complete mathmatical excel spreadsheet. basicly im making a spreadsheet that has all fasits of math in the one spread sheet and ive finished this section but i notised an error in my nested if statement in that it is not fcompleted the reson i created this formula is to get multiple imputs for places and to use different sums in responce if a value is not there.

 

what im in need of is a way to quickly create a nested if form (below is an example of what kind of thing im talking about)

This is a simple intrest segment of my sheet

excel screen shot.jpg

 

BTW if you know of a way to simplifi this plz help

1 Reply

@HomoRogue 

It looks to me as if you might be better served by the IFS function, rather than a long multi-layered nested set of IF functions. Here's a good resource to help understand how the IFS function works.

https://exceljet.net/excel-functions/excel-ifs-function

 

If you want more help, may I recommend you attach an actual copy of the actual spreadsheet--so long as it contains no confidential information. An image doesn't go very far in helping us help you.