View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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%?