Get instant live expert help on I need help with excel rate function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Use the VBA Editor to create a new module.
Function Depreciation (Value, Rate)
Depreciation = Value * Rate
End Function
Solved by G. S. in 30 mins
Use the VBA Editor to create a new module. Type the following VBA code to create a custom depreciation function (be sure to include the blank lines after the first line and before the last line). Save and exit the VBA Editor.
Function Depreciation (Value, Rate)
Depreciation = Value * Rate
End Function
Solved by I. A. in 12 mins
SUMPRODUCT FORMULA IN EXCEL
1 2 3 4
Qty Rate Qty Rate Qty Rate Qty Rate
10 200 5 190 5 180 5 180
Solved by A. A. in 26 mins
In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number.
Solved by E. A. in 28 mins
23. Calculate the internal rate of return in C26 using the IRR function, using profit for the entire time period (including startup and project end).
Solved by A. H. in 20 mins