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?
|