Adjust Formulas for multiple ranges on multiple pages

Twollaston

Board Regular
Joined
May 24, 2019
Messages
229
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
 
Last edited:

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,090,053
Messages
5,412,073
Members
403,411
Latest member
Michlovsky

This Week's Hot Topics

Top