How to create a custom formula in Excel
By
SpreadCheaters
Page last updated:
19/11/2022 |
Next review date:
19/11/2024
You can watch a video tutorial here.
You want to create a custom formula in Excel.
There’s an easy way to do this:
Step 1 – Set up your formula
– Select the cell you would like the result to appear.
– In this case, I want to convert minutes to hours, so I need to divide the minute value by 60.
– Type =A2/60 where A2 refers to the cell containing the minute value.
This is an easy way to create a custom formula in Excel.
