Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · High Priority · Version 2003

Reply Tue 15 Apr 2008, 16:28Delegate Amy said...

Amy has attended:
Excel Intermediate course

Excel

When linking cells from 2 different workbooks, can you combine AND add/subtract/divide etc. another value into it?

For upcoming training course dates see: Pricing & availability

Reply Wed 16 Apr 2008, 08:37 Edited on Wed 16 Apr 2008, 08:40Trainer Pete said...

RE: Excel

Hi Amy, Thank you for your post, welcome to the forum, in answer to your question, yes you can use any of the operators in your linking formula for example in Sheet 3 cell A1 type (or navigate and click on the cells) =(Sheet1!A1-Sheet2!A1) or any other arithmetical operator that you wish including AND and OR, your computation can be as complex as any created on a single worksheet however in your formula you must include the sheet number or name. I hope that helps, best regards Pete.

Excel articles

· What's Better Than the Help Function in Excel? Microsoft Training
· Want To Create A Presentation In Excel?
· How Small Businesses Profit from Outside Excel Training
· Charting Your Success With Excel 2007
· How To Print Worksheets In Excel

Please browse our web site to find out more about
excel one day course london and other Microsoft training courses.

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips