Meaning of a few formulae

msra7hm2

New Member
Joined
Dec 3, 2016
Messages
3
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)))
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
=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.
 
Last edited:
Upvote 0
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
 
Upvote 0
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.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,217,750
Messages
6,138,406
Members
450,134
Latest member
TYoung24

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top