Meaning of a few formulae

[msra7hm2]

Hi

I have a financial model and I am trying to understand a few formulae. I would appreciate if you could translate them into simple words please. Thanks!

=INDIRECT("Currency!"&ADDRESS(14,$A$48+COLUMNS($C$50:C50)))

Cell A48=IF(Capex!B12>0,2,IF(Capex!C12>0,3,IF(Capex!D12>0,4,0)))

 

[JLGWhiz]

=INDIRECT("Currency!"&ADDRESS(14,$A$48+COLUMNS($C$50:C50)))

Equals the value on sheet "Currency" at a cell on row 14 and whatever column is calculated by adding the value in Cell A48 of the active sheet to the numer of columns in the COLUMNS array.

A48=IF(Capex!B12>0,2,IF(Capex!C12>0,3,IF(Capex!D12>0,4,0)))

If the value in sheet "Capex", cell B12 is greater than 0 then Cell A48 of the active sheet equals 2, Else If Cell sheet Capex C12 > 0 then A48 equals 3, Else If cell D12 of sheet Capex > 0 then cell A48 equals 4, Else cell A48 = 0.

The Indirect formula is dependent upon the value derived in the formula for cell A48 value.

 

[msra7hm2]

Equals the value on sheet "Currency" at a cell on row 14 and whatever column is calculated by adding the value in Cell A48 of the active sheet to the numer of columns in the COLUMNS array.
.

What is the number of columns in the COLUMNS array? How do we count them?

Thanks

 

[JLGWhiz]

What is the number of columns in the COLUMNS array? How do we count them?

Thanks

Columns($C$50:C50) yields a value of 1 column - column C. If you move the formula one cell to the right the array becomes Columns($C$50:D50) and yields a value of 2 - columns C And D.
These value become the column designation for the Address(14, ColumnNumber) where ColumnNumber would be the value of the Colums() function the numbers in the Address function represent row,column, much like the Cells() property in VBA. This is all explained in greater detail in the Excel help files, or you can find turials on the web by searching on the function keywords.