I am attempting to create a formula that allows me to increase the percentage of about a 1000 cells. It works fine until I copy the answer to another cell and it gives me 0 or says REF.
Can someone show me exactly how to increase the percentage of a group of cells?
Thanks in advance,
Michael
Hi mgtid,
You should learn about absolute and relative cell references. Can you post an example of your formula or attach an excel file?
Corine
One way to perform math on multiple cells is to use PasteSpecial. Let's say you want to increase cells A1:A1000 by 12% each.
1. In any open cell, put the number 1.12
2. Copy that cell (CTRL+C or Edit -> Copy)
3. Select the range you want to modify (e.g. A1:A1000)
4. Select Edit -> PasteSpecial -> Multiply, then click OK
Your numbers should then be updated. Using PasteSpecial you can perform many tasks that a simple Paste cannot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks