ExcelBanter - Stumped

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Stumped (https://www.excelbanter.com/excel-discussion-misc-queries/183951-stumped.html)

Formula question

Stumped

I seen this formula in a cell but cannot calculate. What does it mean?
=G$16*EI!$F$71

Narendra Boga[_2_]

Stumped

This is a formula that multiplies the cell in current sheet's cell "G16"
with cell "F71" of "EI" named sheet. whereas the $ symbol is for Absolute
reference.

Narendra

"Formula question" wrote:

I seen this formula in a cell but cannot calculate. What does it mean?
=G$16*EI!$F$71

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