ROUNDDOWN function
Excel » Functions » Math and trigonometry » ROUNDDOWN function »
How to use the ROUNDDOWN function
The ROUNDDOWN function calculates a number rounded down based on the number of digits to which you want to round […]
How to calculate the number of weeks between dates
The image above demonstrates a formula that calculates the number of complete weeks between two dates. Column B and column C […]
Rearrange values using formulas
The picture above shows data presented in only one column (column B), this happens sometimes when you get an undesired […]
Hover with mouse cursor to change stock in a candlestick chart
This article demonstrates how to change chart series while hovering with mouse cursor over a series name. The image above […]
Change chart axis range programmatically
This article demonstrates a macro that changes y-axis range programmatically, this can be useful if you are working with stock […]