Excel
Excel: Convert Decimal Time to Hours & Minutes
You can use the following formula to convert a decimal time to hours and minutes in Excel:
=TEXT(B2/24, "h:mm")
This will convert the decimal time in...
Descriptive Statistics in Excel
How to Find Y-Intercept of a Graph in Excel
The y-intercept of a graph represents the point where a line crosses the y-axis when x is equal to zero.
To find the y-intercept of...
Excel
How to Connect Points in a Scatter Plot in Excel
Often you may want to connect the points in a scatter plot in Excel.
Fortunately this is easy to do and the following step-by-step example...
Excel
Excel: Search for Value in List and Return Yes or No
You can use the following basic syntax to check if a value in a cell exists in a list in Excel and return either...
Excel
Excel: How to Create IF Statement with Four Outcomes
You can use the following basic syntax to create an IF statement with four outcomes in Excel:
=IF(B2>30,"Outcome1",IF(B2>25,"Outcome2",IF(B2>20,"Outcome3","Outcome4")))
This particular function looks at cell B2 and...
Excel
Excel: How to Convert Minutes to Hours and Minutes
Often you may want to convert minutes to hours and minutes in Excel.
Fortunately this is easy to do and the following step-by-step example shows...
Descriptive Statistics in Excel
Excel: How to Use MIN Function and Exclude Zero
You can use the following basic syntax to use the MIN function in Excel to find the minimum value in a range while excluding...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read