Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Nancy M
 
Posts: n/a
Default 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   Report Post  
Chip Pearson
 
Posts: n/a
Default

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   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search column and move text formula tommy Excel Discussion (Misc queries) 0 February 8th 05 07:55 PM
How do I create a formula in excel to automatically copy text fro. ijgolding Excel Discussion (Misc queries) 1 January 31st 05 01:37 PM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 08:27 PM
Total remaining formula jbsand1001 Excel Worksheet Functions 2 January 6th 05 05:17 PM
calculate which cells in column A will give me the total of column Ken Excel Worksheet Functions 4 January 6th 05 07:25 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"