| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Create an if-then formula in Excel to limit column total?
I want to limit a column total to 100 percent if the column adds up to
greater than 100 percent. Is there an if-then statement for Excel? |
|
#2
|
|||
|
|||
|
You could use the MIN function.
=MIN(100,SUM(A1:A10)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nancy M" <Nancy wrote in message ... I want to limit a column total to 100 percent if the column adds up to greater than 100 percent. Is there an if-then statement for Excel? |
|
#3
|
|||
|
|||
|
Good chance if it is formatted as percents that you might use
=Min(1,Sum(A1:A10)) and format the cell as percent. -- regards, Tom Ogilvy "Chip Pearson" wrote in message ... You could use the MIN function. =MIN(100,SUM(A1:A10)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nancy M" <Nancy wrote in message ... I want to limit a column total to 100 percent if the column adds up to greater than 100 percent. Is there an if-then statement for Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search column and move text formula | Excel Discussion (Misc queries) | |||
| How do I create a formula in excel to automatically copy text fro. | Excel Discussion (Misc queries) | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
| Total remaining formula | Excel Worksheet Functions | |||
| calculate which cells in column A will give me the total of column | Excel Worksheet Functions | |||
Linear Mode
