98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Medium Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Bracketed negative numbersOften Excel users wish to display negative numbers in colour red and bracketed |