simplify formula

[4rfvgyhnjik]

this formula is very long and i believe there is a way to simplify it

=IF(AM8=0,IF(SUM(E8,G8,I8,K8,M8)<50,50+SUM(O8,Q8),SUM(E8,G8,I8,K8,M8,O8,Q8)),IF(AM8=1,IF(SUM(E8,G8,I8,K8,M8,O8)<50,50+Q8,SUM(E8,G8,I8,K8,M8,O8,Q8)),IF(AM8=2,IF(SUM(E8,G8,I8,K8,M8,O8,Q8)<50,50,SUM(E8,G8,I8,K8,M8,O8,Q8)),IF(AM8+AN8=2,IF(SUM(E8,G8,I8,K8,M8,Q8)<50,50,SUM(E8,G8,I8,K8,M8,Q8)),IF(AM8+AO8=2,IF(SUM(E8,G8,I8,K8,M8,O8)<50,50,SUM(E8,G8,I8,K8,M8,O8)),IF(AN8+AO8=2,IF(SUM(E8,G8,I8,K8,M8)<50,50,SUM(E8,G8,I8,K8,M8))))))))

any help given is greatly appreciated

 

[shemayisroel]

The best way to get the possible answer in the shortest time frame is to post some sample data along with your expected result(s)

 

[Jonmo1]

The best way to get the possible answer in the shortest time frame is to post some sample data along with your expected result(s)

And an explaination in words what you want the formula to do.


It is very difficult to read a formula / figure out it's purpose and intended results / and make it better.

Much easier if you just describe what it does, give examples and expected results.