Thank you Dave

"Dave Peterson" wrote:

=min(150%,yourformulahere)

=min(150%,sum(a1,b3))

for example



lennysc14 wrote:

How do I ensure that the resultant sum of two cells A & B expressed as a
percentage in cell C does not exceed a set percentage of say 150%?

--

Dave Peterson