Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |