| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if one cell greater than another cell, how to change colors? | Excel Discussion (Misc queries) | |||
| If sum greater than 12 use 12 | Excel Discussion (Misc queries) | |||
| Greater Than but Less than | Excel Worksheet Functions | |||
| change cell value greater than another cell value using formulas | Excel Worksheet Functions | |||
| How go I get cells to change color if a date is greater than 365 . | Setting up and Configuration of Excel | |||
Linear Mode
