excell

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excell

Excell

resolvedResolved · Low Priority · Version 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:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips


Server loaded in 0.09 secs.