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

excel

ResolvedVersion 2003

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?

Edited on Wed 16 Apr 2008, 08:40

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 tip:

Shared Conditional Formatting

In a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones.

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