Formulas entered in Excel are relative to the cells they are entered in.
Now you want copy the “result” of a formula to another cell. So you go ahead and copy the cell where the result is and “paste” it it into the new cell.
Whoops! What hapened? The reult is not the same as what you wanted to copy….formulae are relative and the new cell will refer to different cells… damn frustrating!
Solution: When you want to paste the result of a formula into a new cell choose “Paste Special” from the Edit menu and choose Values from the dropdown menu… Voila… your reult is in the new cell without the formula.
If you’re frustrated with you Paper Work and need an experienced Paper Work expert to help you Call Peter
PAS Administrative Support Services
Peter 613-347-9893
pas-admin@sympatico.ca
