Mary has attended:
Excel Intermediate course
Formulas
Why is it when I try to duplicate a formula that someone else has created it will not work, is there a finite number of times that you can copy and paste, using "all formulas"?
thanks
RE: Formulas
Hello Mary
Thank you for your question and welcome to the forum.
The problem with copying formulas that other people have created sometimes is that you can do this without checking whether the formula you are copying will perform the calculation you want it to or not.
There could be a number of reasons why a formula will not work therefore this question is difficult to answer.
The Microsoft web site has a tutorial on formulas which includes a section on reference type which you may find useful:
http://office.microsoft.com/training/Training.aspx?AssetID=RC061079311033& ;CTT=6&Origin=RC061079311033
Amanda
