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