Thread
:
Create an if-then formula in Excel to limit column total?
View Single Post
#
2
Chip Pearson
Posts: n/a
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 With Quote