Do not let a percentage be greater than 100

T

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
 
G

Glenn

triplejay23 said:
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
Click to expand...


=MIN(1,150/148)
 
Top