formulas

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · 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


 

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips


Server loaded in 0.12 secs.