98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · High Priority · Version 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?
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. |