insert figure end of formula

[jw01]

Hello

Happy holidays to everyone; just need some guidance/help regarding adding a figure to a formula.

i have quite a few formulas pasted in different range
i.e. R12:S3, X12:Y38 etc

and they all contain a formula:
=(I12-(('US (Data)'!Q13-'US (Data)'!W13)/('US (Data)'!E13)/(('US (Data)'!Q13-'US (Data)'!W13)/('US (Data)'!E13))))

now bc this is a year over year growth, i have to multiply it by 100 to get a percentage....and i dont want to go in each cell and manually insert *100 at the end of the formula....can anyone help?

end result should be this on the ranges
=(I12-(('US (Data)'!Q13-'US (Data)'!W13)/('US (Data)'!E13)/(('US (Data)'!Q13-'US (Data)'!W13)/('US (Data)'!E13))))*100


pls and thx you for your time

[tpoynton]

use search and replace (ctrl H) to find the end of the formula, just specify to look in formulas in the options if it is not set already. For example, if this part of the formula is not in another formula:

find: ))))
replace: ))))*100

[jw01]

thxs alot :) happy holidays