ExcelBanter - Should be simple

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Should be simple (https://www.excelbanter.com/excel-worksheet-functions/257232-should-simple.html)

Gotroots

Should be simple

I want to show a result of a formula contained in another workbook.

This should surely be a simple formula such as:

=[Samplebook_A.xlsm]A!$AA$11

I am getting zero returned when 1 is the result.

Am I missing something obvious.

Gotroots

Gotroots

Should be simple

False alarm. The formula should be instead:

=[Samplebook_A.xlsm]A!AA11

Sorry.

Gotroots

"Gotroots" wrote:

I want to show a result of a formula contained in another workbook.

This should surely be a simple formula such as:

=[Samplebook_A.xlsm]A!$AA$11

I am getting zero returned when 1 is the result.

Am I missing something obvious.

Gotroots

All times are GMT +1. The time now is 02:35 PM.