LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Maximum value in a cell

I am trying to set a maximum value in a cell. I have a percentage calculated
in one cell, from time to time the precentage is greater than 100%. Is it
possible to set the formula to only allow a maximum of 100%?
 
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
Address of Maximum value in Cell Session101 Excel Worksheet Functions 1 April 12th 06 09:06 PM
Maximum and minimum cell value sharkfoot Excel Discussion (Misc queries) 3 March 5th 06 11:08 PM
Maximum data in cell Rachael Excel Discussion (Misc queries) 12 January 25th 06 05:46 PM
Which the maximum of characters of value in a cell? Malisky Excel Discussion (Misc queries) 1 January 12th 06 01:33 PM
format cell with maximum value Frank Drost Excel Discussion (Misc queries) 8 November 22nd 05 04:45 AM


All times are GMT +1. The time now is 02:09 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"