I think Trevor's should be

=IF(SUM(E18:E23)40,SUM(E18:E23)-40,0)

and here is an alternative

=MAX(SUM(E18:E23)-40,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Kerri Olsen" wrote in message
...
I need help writing a formula

if range E18:E23 is greater than 40, I want the number E18:E23-40 entered
into the cell, if false 0
--
Kerri