I would like to know if you can add a fomula to a cell that is linked?

I'm linking cells in a worksheet from other worksheets, but my main worksheet that contains the links, I need to add 1.5% to the amount that has been linked from another source worksheet, can this be done and how?

I would like to know if you can add a fomula to a cell that is linked?
does this site help at all





http://www.exceluser.com/help/formula/lo...
Reply:YOu can't do it in the actual cell because obviously that would automatically delete the link. What you can do is in another column create a formula so if your links are in column A, in column b appropriate rows use the formula =a2 (if that's where the first link is situated) =a2*1.5%+a2 so you get the total of a2 plus the 1.5%. If you don't want the original figure to show, you can't delete it otherwise the formula in b column would show zero, but you could hide Column A so that you show only the added value column.
Reply:Let us think you have two worksheets A and B in the same excel file and in the work sheet A, you want to put the result in cell "D3" (after adding 1.5% to the value which is present in worksheet B's cell C5).


Now you have to simply go to the cell D3 of worksheet A and


write the formula =(B!C5 * 1.5%) + B!C5.





If your work sheet name contains spaces put it in single quotes.





In the above example instead of B if you have "My Sheet", then the formula should be =('My Sheet'!C5 * 1.5%) + 'My Sheet'!C5.

polish