Thread: Need help with a formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
  
Posts: 595
Default Need help with a formula
On Sun, 3 Aug 2008 14:13:00 -0700, BruceK
wrote:

I need help figuring out a formula? Here is what I want to do

I want one cell to add up a column and if that number dosent reach 40 then
it takes more away from another cell but it only displays the 40 or lower and
then anything over the 40 will be displayed in another cell

=MIN(40, SUM(A1:A100))
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com
Reply With QuoteReply With Quote