Forum Discussion
nested if statement generator
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 ...
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.