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

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.11 secs.