Thread
:
how do I ensure that the sum of two cells does not exceed a set fi
View Single Post
#
3
Dave Peterson
Posts: n/a
=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
Reply With Quote