Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training - Formulas
Resolved · Low Priority · Version Standard
Gerald has attended:
Excel Introduction course
Excel Intermediate course
what are the key stages of writing a formula?
Hi Gerald,
Thanks for the question
The fundemental rule is to press = at the beginning, then you must put the cell ref then the operator (+ - / or *) and continue until you decide you have finished then you press enter. So for example =A1+B1+C1 (enter). Also remember excel follows the rules of BODMAS so 1+2*3 will be 7 because the multiplication comes before the addition.
If there is anything specific you would like me to help you with let me know
Tracy
|
Excel tip:Hide separate columns in Excel 2010If you want to hide columns not adjacent to each other for example, Columns A, C and E then:- |
We'll call during UK business hours
Server loaded in 0.08 secs.