INDIRECT function

The INDIRECT function returns the reference specified by a text string. The INDIRECT function syntax is as follows: = INDIRECT ( reference_text ; reference_style ) Reference text can be any text that the function can “convert” to a cell reference. Reference style represents the style of referencing cells in Excel. If omitted or TRUE, reference text is interpreted as an A1 style reference i.e. the default style of referencing cells in Excel. If FALSE, reference text is interpreted as an

Nesting formulas, functions and conditional statements in the SUMIFS criteria

We’ve previously established what are the rules of writing criteria in the SUMIFS function: we can reference any cell we can enter any number directly in the function we can enter text directly in the function, nested inside of quotation marks [“”] logical test is nested inside of quotation marks [“”], with comparison operator coming first and a number second. The story however does not end there, and advanced users can do even more with the SUMIFS function.   We

Numbers in Excel

How are numbers stored, formatted and calculated? When dealing with numbers in Excel we should be aware of a few things: numbers in Excel can be formatted in many ways: plain numbers, currency, percentage, date etc. no matter how they are formatted and possibly edited, underlying values saved in cells are still decimal numbers those decimal numbers that Excel uses and calculates with go up to 15 decimal places (and even with that, there are caveats) this is not changed