View Single Post
  #4   Report Post  
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
...
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?