# Meaning of a few formulae

#### msra7hm2

##### New Member
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!

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.
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:
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

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:

Replies
2
Views
345
Replies
1
Views
329
Replies
3
Views
272
Replies
1
Views
145
Replies
5
Views
357

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.

### Which adblocker are you using?

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

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