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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
=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:

msra7hm2

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

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
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:

Watch MrExcel Video

Forum statistics

Threads
1,130,444
Messages
5,642,180
Members
417,259
Latest member
gtacw

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
Top