View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Tareeka Tareeka is offline
external usenet poster
 
Posts: 2
Default Maximum value in a cell

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

" wrote:

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/C11,1,B1/C1) you should get what
you need.

= Marchand =


On Mar 5, 9:22 am, 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%?