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.