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

excell

ResolvedVersion 2003

Dan has attended:
Project Intro Intermediate course

Excell

how do I make excell do calculations for me

RE: excell

Hi Dan

Thank you for your question; and welcome to the forum.

It is probably easiest to explain this with an example. Say you have the number 1 entered into cell A1 in a spreadsheet; and the number 2 entered into B1.

If in cell C1 you entered =a1+b1 and pressed Enter, this would give you the result of adding the contents of A1 and B1 together (in this example, 3).

Replacing the + in the formula above with a * will the contents of A1 and B1 together; a / will divide; and - will subtract.

I hope this helps.
Amanda

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.