Nesting issues

I don't have a lot of experience with excel, and I'm trying to use an IF statement with 15 nested IFs. I cannot save it as xlsx because the document needs to be in a format accessible to people with older computers. Is there a way I can get around this by using another type of statement?

Thanks so much. I appreciate any help. If someone thinks they can I'd be happy to send them the actual formula I am working on.

Shmem

Welcome to the forum. Yes, we would need to see the formula you're working with to help. Often, Lookup, Vlookup, or some Index/Match function can take the place a long series of nested Ifs.

Wow that was fast. Thanks! Here is the formula. It works when I have only a few statements in there, so I know that much works at least.

=if(and((E181=0),(E183=0),(L709<>""),(E185=0)),(((SUM(N181:O186))/30)*100),IF(AND((E181=0),(E183=0),(L709<>"")),(((SUM(N181:O186))/50)*100),IF(AND((E181=0),(L709<>""),(E185=0)),(((SUM(N181:O186))/50)*100),IF(AND((E181=0),(E183=0),(E185=0)),(((SUM(N181:O186))/45)*100),IF(AND((E182=0),(L709<>""),(E185=0)),(((SUM(N181:O186))/45)*100),IF(AND((E181=0),(E183=0)),(((SUM(N181:O186))/65)*100),IF(AND((E181=0),(L709<>"")),(((SUM(N181:O186))/65)*100),IF(AND((E181=0),(E185=0)),(((SUM(N181:O186))/65)*100),IF(AND((E182=0),(L709<>"")),(((SUM(N181:O186))/65)*100),IF(AND((L709<>""),(E185=0)),(((SUM(N181:O186))/65)*100),IF(AND((E182=0),(E185=0)),(((SUM(N181:O186))/60)*100),IF(E181=0),(((SUM(N181:O186))/85)*100),IF(E182=0,(((SUM(N181:O186))/80)*100),IF(L709<>"",(((SUM(N181:O186))/85)*100),IF(E185=0,(((SUM(N181:O186))/80)*100),((SUM(N181:O186))))))))))

In case you need to know what I'm trying to do - I'm trying to sum up a group of cells and that sum will be divided by a number that depends on 4 cells, and how many/what combination of them are equal to zero (or blank for the case of L709). Is this confusing? It's hard to explain!

You use E181, E182, E183, E185, and L709. Which of those is not included in the four that this formula depends on. Also, it seems that each of these has a value that they take away from 100. E182, E183, and E185 seem to take away 20 from the divisor each if not blank while the other two take off .15 each, yet that doesn't seem entirely consistent as with your four cells in the first IF all evaluating to true, only 70 is taken off rather than 75. Do they each have values assigned and, if so, what are these values for each cell?
This formula can be much simpler if this is the case, although I can make it work if it is not.

urk!
Please post an example, it is confusing if you aren't familiar with the data,

CC

One thing that would help, just in the eyesore dept., is to take out all the instances of SUM(N181:O186) and put just one at the beginning of the formula before the If statements begin. Also, remove *100 and stick it after the Ifs just once. It's possible to do this with just seven nested Ifs, but I'm waiting on which of the five cells you listed is a typo or whether saying it was four cells was the typo.

If each cell takes off a given amount from the divisor, you could use =SUM(N181:O186)*100/(100-((E181=0)*.15+(E183=0)*.2+(E185=0)*.2+(L709<>"")*.15)), adjusting the multiplier for each cell as necessary.

Wow. I am overwhelmed with the help. Thanks!

I did make a mistake - sorry! There should be no E183 values. It should be E182.
You are right darkyam - each of the cells does take off a given amount from 100. I am creating a final score for a document, and when some sections are not applicable I have to weight the final score differently. So, for example, if section A (cell E181) is not applicable - and therefore equal to 0, the total is now scored out of 85 instead of out of 100.

Here are the values that will be subtracted from 100 for each cell (and they are cumulative).
E181 - 15
E182 - 20
L709 - 15
E185 - 20

I know it's complicated - I'm not sure how to explain it any better.

You should be able to use my formula then, replacing E183 with E182, or shg's first one, if you prefer.

Thanks again. I am going to try them. I appreciate everyone's help.