Contradicting conditions?

[tamiwami]

Im new to excel, Im trying to create a formula with many conditions, but i think they are contradicting each other. Looking for some assistance.
This is what I've got:

=MAX(0,IF(SUM(K10:K23)>80,0,IF(SUM(K10:K23)<80,80-(SUM(K10:K23)))))

Now I would like to add that if K10:K23 = 0,0 but that doesn't seem to work when I add it.
Any ideas?

 

[Joe4]

Please explain, in plain English, exactly what you want this formula to do.

 

[tamiwami]

Its for a time sheet and this cell will calculate the hours needed to reach 80. So essentially if K10:K23(hours worked) is greater than 80, this would be 0, but if it was less than 80 it would calculate the remainder. So far what I have works but I want to add that if K10:K23 is 0 then this cell diplays 0.

 

[tamiwami]

Its for a time sheet and this cell will calculate the hours needed to reach 80. So essentially if K10:K23(hours worked) is greater than 80, this would be 0, but if it was less than 80 it would calculate the remainder. So far what I have works but I want to add that if K10:K23 is 0 then this cell displays 0.

 

[Joe4]

Try this:

=IF(SUM(K10:K23)=0,0,MAX(80-SUM(K10:K23),0))

 

[tamiwami]

That worked Great! Thank you!

 

[Joe4]

You are welcome.