98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007
Excel 2007
Resolved · Low Priority · Version 2007
Tue 15 Jul 2008, 16:05Delegate Ntashie said...
Wed 16 Jul 2008, 08:26Trainer Pete said...
RE: excel 2007
Hi Ntashie,
Thank you for your post, welcome to the forum;
In answer to your question:
Always consider BODMAS when you enter formulas, this is the sequence that Excel follows when it calculates a formula
BODMAS stands for:
B=() Brackets - Anything in Brackets will be calculated from the innermost set first
O=^ Ordinals - To specify the exponent =2^3, which means 2 raised to the third power.
D=/ Division - To divide numbers =A1/A2
M=* Multiplication - To multiply numbers =A1*A2
A=+ Addition - To add numbers =A1+A2
S=- Subtraction - To subtract numbers =A1-A2
I hope that has helped. Regards Pete
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:Hide columns in an Excel 2010 WorksheetIf you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns. |
