View Full Version : insert figure end of formula

12-23-2010, 01:30 PM

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

12-23-2010, 01:46 PM
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

12-23-2010, 02:09 PM
thxs alot :) happy holidays