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

formula

ResolvedVersion 2003

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

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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.18 secs.