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

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