Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 ... 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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Height of Cell limit | Charts and Charting in Excel | |||
Is there a limit on how much information a cell can hold? | Excel Discussion (Misc queries) | |||
limit number of characters in a cell | Excel Discussion (Misc queries) | |||
Excel Solver: How do I limit the contents of a cell to 1=True or 0 | New Users to Excel | |||
limit worksheet view to specified cell range | Setting up and Configuration of Excel |