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?

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 M@discussions.microsoft.com> wrote in message
news:64FB1BF8-A8BB-4B0E-99BA-AD5620899D20@microsoft.com...
>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?

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" <chip@cpearson.com> wrote in message
news:u2FcdLhEFHA.2300@TK2MSFTNGP15.phx.gbl...
> 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 M@discussions.microsoft.com> wrote in message
> news:64FB1BF8-A8BB-4B0E-99BA-AD5620899D20@microsoft.com...
> >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?
>
>