View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
 
Posts: 117
Default Using IF Function

=IF(SUM(B16:B19)48,SUM(B16:B19)-48,SUM(B16:B19))

Substitute your range of cells as required.

"pjb" wrote:

I am trying to create a formula that will sum a list of cells and if the
total exceeds a certain number it will return the number that is above that
number. ie:sum = 48, I want the formula to show 8. thanks