Help with a IF formula

[Rog]

This should work :

=MAX(0,SUM(B7:G7)-30)

 

[Matt]

Thanks so much that works great. Matt

This should work :

=MAX(0,SUM(B7:G7)-30)

 

[Matt]

Thanks! That works great!

This should work :

=MAX(0,SUM(B7:G7)-30)