Set a limit on cell value, so that it does not exceed a set figure

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I ensure that a value displayed in a cell does not exceed a set figure?
 
If this is a cell into which people input data check out <data><validation>
if this is from a formula
=min(Value,formula)
 
I need to ensure that the percentage sum of two cells does not exceed a set
figure
 
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 said:
I need to ensure that the percentage sum of two cells does not exceed a set
figure
Click to expand...
figure?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you limit the total allowed for a group of cells? 1
Problem printing a large excel cell 5
Returning Desired Results 5
cell value condtions 1
can I get excel to send an email based on a cell result? 1
Conditional formatting for values in a column that exceed a set limitwhen summed 4
formula for 55% of a cell reference cannot exceed 156? 4
if the cell value exceeds the limit to have a dialog box appear 2

Back
Top