Thread: Sum = to greater than, change it to 1
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Sum = to greater than, change it to 1
Try this in A9

=MIN(1,(SUM(A1:A8)))

Mike

"Kim" wrote:

Cells A1....A8 are summed from other columns.
In cellA9 I want a formula that says it the sum of A1..A8 is greater than
$1.00 then make this cell only $1.00.
Reply With QuoteReply With Quote