View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Daniel.C Daniel.C is offline
external usenet poster
 
Posts: 43
Default if formula needed

=IF(A1B1+B2,MIN(A1-(B1+B2),C3),C3)
--
Regards.
Daniel
"Theresa" a écrit dans le message de
news: ...
Hello, If A1 is greater than the sum of B1+B2, return the difference of A1
minus the sum of B1+B2 but not greater than the value of C3. If false
return
value of c3.