Maximum value in a cell
Use the MIN function.
=MIN(your formula, 100%)
This returns whichever value is lower between "your formula" and 100%.
HTH,
Elkar
"Tareeka" wrote:
I am trying to set a maximum value in a cell. I have a percentage calculated
in one cell, from time to time the precentage is greater than 100%. Is it
possible to set the formula to only allow a maximum of 100%?
|