Remember Me?

#1
 Nancy M Posts: n/a
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
 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?

#3
 Tom Ogilvy Posts: n/a

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post tommy Excel Discussion (Misc queries) 0 February 8th 05 07:55 PM ijgolding Excel Discussion (Misc queries) 1 January 31st 05 01:37 PM Cindy Charts and Charting in Excel 3 January 13th 05 08:27 PM jbsand1001 Excel Worksheet Functions 2 January 6th 05 05:17 PM Ken Excel Worksheet Functions 4 January 6th 05 07:25 AM

All times are GMT +1. The time now is 12:01 AM.