jw01

12-23-2010, 01:30 PM

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

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