Adjust Formulas for multiple ranges on multiple pages

[Twollaston]

I need to change the formulas on several pages for several ranges, by adding an if statement that says if the result is greater than 100% then show 100% or else show the normal result of the formula. I'm not quite sure how to do it without breaking my back. Ranges are the same on all the pages i need to adjust but all the pages don't need to be adjust, only like 13 out of the 16 pages should be adjusted.

Details
Ranges needed to change on each page:
L14:O22, S14:U21, X14:Z21, AC14:AE21,
L31:O39, S31:U38, X31:Z38, AC31:AE38,
L48:O56, S48:U55, X48:Z55, AC48:AE55,
L65:O73, S65:U72, X65:Z72, AC65:AE72,
L82:O90, S82:U89, X82:Z89, AC82:AE89,
L100:O108, S100:U107, X100:Z107, AC100:AE107


Pages wanting to apply to(by worksheet number):
Worksheets(1)
Worksheets(2)
Worksheets(3)
Worksheets(5)
Worksheets(6)
Worksheets(8)
Worksheets(9)
Worksheets(11)
Worksheets(12)
Worksheets(14)

Set current formula(which will be different based on the ranges) = X

New Formula:
=If(x>100%,”100%”,x)

If someone has a macro that can do this easily let me know.

Thanks

 

[Special-K99]

You could replace that formula with

MIN(100%,x)

 

[Twollaston]

You could replace that formula with

MIN(100%,x)

Thank you sir