98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · High Priority · Version 2003
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?
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly create a list of numbersThe fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next. |
