Thread: I want to auto-sum and not exceed a certain number
View Single Post
  #5   Report Post  
mmsamaddar mmsamaddar is offline
Junior Member
  
Posts: 1
Default
Quote:
Originally Posted by Gord Dibben View Post
=MIN(100,SUM(A1:A10)) will return 100 if the SUM is more than 100


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 00:43:01 -0800, jt4lsu
wrote:

I have a column that I am using auto-sum. The total of that column cannot
exceed a certain number. What is the formula?
I want to auto-sum and not exceed a certain number, if exceed, show a pop up message warning. Thanks in advance for response
Reply With QuoteReply With Quote