Do not let a percentage be greater than 100

[triplejay23]

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

 

[Glenn]

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

=MIN(1,150/148)

 

[triplejay23]

GOT IT! THANKS!!!!!!!!!!!!!!!!!

JJ

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

[quoted text clipped - 9 lines]

Thanks!
John

=MIN(1,150/148)