Thread: Sum = to greater than, change it to 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim Kim is offline
external usenet poster
  
Posts: 284
Default Sum = to greater than, change it to 1
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