ExcelBanter - Sum = to greater than, change it to 1

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sum = to greater than, change it to 1 (https://www.excelbanter.com/excel-worksheet-functions/193510-sum-%3D-greater-than-change-1-a.html)

Kim

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.

Mike H

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.

Gord Dibben

Sum = to greater than, change it to 1

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

Format to Currency with 2 DP

Gord Dibben MS Excel MVP

On Wed, 2 Jul 2008 11:42:01 -0700, 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.

All times are GMT +1. The time now is 07:37 AM.