Maximum value in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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%?
 
You didn't give the formula in the cell currently, so let's say it's:
=B1/C1
If you change this formula to =IF(B1/C1>1,1,B1/C1) you should get what
you need.

= Marchand =
 
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
 
Use the MIN function.

=MIN(your formula, 100%)

This returns whichever value is lower between "your formula" and 100%.

HTH,
Elkar
 
THANK YOU, this is it!! You have no idea how long I have been trying to
figure this out!!
 
Back
Top