Maximum value in a cell
Maybe something like this:
A1: (a number)
B1: (a percent)
This formula multiplies the value in A1 by the lesser of the B1 Percent OR
100%
C1: =A1*MIN(B1,100%)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"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%?
|