Remember Me?

#1
July 5th 05, 09:07 PM
 lennysc14 Posts: n/a
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
July 5th 05, 09:15 PM
 bj Posts: n/a

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
July 5th 05, 09:20 PM
 lennysc14 Posts: n/a

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
July 6th 05, 04:08 AM
 RagDyer Posts: n/a

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post az Charts and Charting in Excel 1 June 28th 05 01:53 AM [email protected] Excel Discussion (Misc queries) 1 May 11th 05 03:56 PM abfabrob Excel Discussion (Misc queries) 9 February 11th 05 05:19 PM Brian Patrick Gilbert New Users to Excel 0 February 8th 05 04:29 PM 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.