Thread: Do not let a percentage be greater than 100
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
triplejay23 triplejay23 is offline
external usenet poster
  
Posts: 2
Default Do not let a percentage be greater than 100
I am calculating percentages, to come up with the percentage, in some cells I
am taking a larger number and dividing by a smaller number, therefore ending
up with a percentage greater than 100.

E.g. 150/148 = 101.35%

How can I format my percentage cells so any percentage that is GREATER than
100 ONLY DISPLAYS as 100?

Is there a way to do that???

Thanks!
John

Reply With QuoteReply With Quote