Limiting Results to a maximum # of 100

[BJSax]

I am using a simple formula in a cell like below and have the cell formultated to calculate as a percentage.

=WKSHT2!D136/WKSHT2!C136

But i want to make sure that if the returned answer is over 100% that what displays is "100%". In other words I want the max answer to be 100%. How do I do this?

 

[jlatendre]

Hello,
=if((WKSHT2!D136/WKSHT2!C136)>100%,100%,WKSHT2!D136/WKSHT2!C136)
Try this and let me know,

Jesse

 

[Ruddles]

Or: =MIN(WKSHT2!D136/WKSHT2!C136,1)

 

[barry houdini]

You could use MIN function

=MIN(1,WKSHT2!D136/WKSHT2!C136)