Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 5th 05, 09:07 PM
lennysc14
 
Posts: n/a
Default Set a limit on cell value, so that it does not exceed a set figure

How do I ensure that a value displayed in a cell does not exceed a set figure?

  #2   Report Post  
Old July 5th 05, 09:15 PM
bj
 
Posts: n/a
Default

If this is a cell into which people input data check out <data<validation
if this is from a formula
=min(Value,formula)

"lennysc14" wrote:

How do I ensure that a value displayed in a cell does not exceed a set figure?

  #3   Report Post  
Old July 5th 05, 09:20 PM
lennysc14
 
Posts: n/a
Default

I need to ensure that the percentage sum of two cells does not exceed a set
figure

"lennysc14" wrote:

How do I ensure that a value displayed in a cell does not exceed a set figure?

  #4   Report Post  
Old July 6th 05, 04:08 AM
RagDyer
 
Posts: n/a
Default

If the set figure is 100, try any of these:

=MIN(A1*B1,100)
=MIN(A1+B1,100)
=MIN(SUM(A1:A25,100)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"lennysc14" wrote in message
news
I need to ensure that the percentage sum of two cells does not exceed a

set
figure

"lennysc14" wrote:

How do I ensure that a value displayed in a cell does not exceed a set

figure?



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
Height of Cell limit az Charts and Charting in Excel 1 June 28th 05 01:53 AM
Is there a limit on how much information a cell can hold? [email protected] Excel Discussion (Misc queries) 1 May 11th 05 03:56 PM
limit number of characters in a cell abfabrob Excel Discussion (Misc queries) 9 February 11th 05 05:19 PM
Excel Solver: How do I limit the contents of a cell to 1=True or 0 Brian Patrick Gilbert New Users to Excel 0 February 8th 05 04:29 PM
limit worksheet view to specified cell range Mike Setting up and Configuration of Excel 2 December 17th 04 12:13 AM


All times are GMT +1. The time now is 08:45 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017