COUNTBLANK Formula in Excel
How to Use the COUNTBLANK Formula in Excel The COUNTBLANK formula in Excel is used to count the blank cells within a selected range. Depending on the analysis that you’re performing, this could come in handy as you do not have to manually Formula explanation: • Range:...
FORMULA TEXT function in Excel
How to Use the FORMULA TEXT function in Excel The Formula TEXT function in Excel is used to return a formula as text. If you have got a string of formula that is used as an equation within a cell, you can use the formula text formula and it will actually write out...
VLOOKUP Formula in Excel
How to Use the VLOOKUP Formula in Excel When you have a specific item you’d like to lookup in a table and there is only one of that item in the table i.e. it is unique. This uses a vertical lookup. Separately, you could use the HLOOKUP formula but the HLOOKUP...
SLOPE Formula in Excel
How to Use the SLOPE Formula in Excel The SLOPE formula is a statistical function in excel that can be used to return the slope of the linear regression line through data points. The SLOPE formula is the vertical distance divided by the horizontal distance between any...
