Multible if statements with different cells and different criteria and different sums

So I would like to do something like this

If AM5=1 then SUM(AG5:AL5) if not then SUM(AF5:AL5)

I also want it to do this

if AN5=1 then SUM($AF5-($AF5*0.2),$AG5:$AL5) if not then SUM(AF5:AL5)


I can get it do add up my formula if I sperate it out. It's when I put it together that it has issues.

so I have

=IF($AN5=1,SUM($AF5-($AF5*0.2),$AG5:$AL5),SUM($AF5:$AL5)),IF($AM5=1,SUM($AG5:$AL5),SUM($AF5:$AL5))

It returns an #VALUE! error.

I think it is just a matter of moving some parentheses around or maybe I need to make it a nested IF. I just don't get what I'm doing wrong. I think I've been looking at it too long.

hoping someone can help

Please Login or Register  to view this content.

Can $AN5 and AM5 =1 at the same time?
alternatively:

Please Login or Register  to view this content.