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 » Formula
Formula
Resolved · Low Priority · Version 2003
Mon 13 Oct 2008, 15:50Delegate Joanna said...
Joanna has attended:
Word Intermediate course
Excel Introduction course
PowerPoint Introduction course
Formula
Could you send some typical formulas and when to use open brackets and close brackets
Tue 14 Oct 2008, 14:37Trainer Mark said...
RE: Formula
Hi Joanna
How are you today, thanks for your question
The most common formulas to use are as follows:
Sum, Average Max and Min
you can find these by going to the Insert menu - click function
when the function window comes up look through the list of most recently used
As for when to use brackets this is as follows
e.g. =sum(b4:b10)
e.g. =average(b3,b7,h10,g8)
the brackets are use to surround a range of cell like they are above
If you have any other queries please reply to this post
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
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:Checking formulas with multiple operatorsWhen dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right: |
