| 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. |
| 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 | |||
Threaded Mode
