Min and Max formula's

[Longtallsally]

Hi all,

I am hoping that someone here can help me as i am struggling to get a formula to do what i want, perhaps its not even possible!

I have a spreadsheet that i am calculating days and amounts.

I need the formula to add all the days and if the sum is less that 30 to return 0, if the sum of days is more than 30 i need it to return how many more than 30 it is.

Hope that makes sense and that someone can help, this is driving me batty!

Thanks in advance for any help.

S

 

[NBVC]

Try something like:

=MAX(0,SUM(E5:E9)-30)

where E5:E9 is the range containing the number of days.