how do I ensure that the sum of two cells does not exceed a set fi

lennysc14 · Jul 5, 2005

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

Anne Troy · Jul 5, 2005

What do you want to occur if it DOES?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

Dave Peterson · Jul 5, 2005

=min(150%,yourformulahere)

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

for example

lennysc14 · Jul 5, 2005

Thank you Dave

Dave Peterson said:
=min(150%,yourformulahere)

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

for example