“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

I'm trying to make a VBA function with two arrays; the first array has the numeric values while the second array has the names. The function will find the value in the first array that is the largest and return the corresponding name (from the second array).

Solved by D. Y. in 11 mins

I need an IF function. the problem is: use the IF function to test whether G6 is greater than 8. If it is, return the value cell G6 minus 8; otherwise, return the value 0

Solved by Z. A. in 28 mins

Hey I need help with VBA. The first functions that you will create are helper functions that can be used by otherfunctions. Function FindMax(valueArray, nameArray) As String This function takes in two arrays; the first array has the numeric values while thesecond array has the names. The function will find the value in the first array that isthe largest and return the corresponding name (from the second array). For instance, if the valueArray = (10, 20, 5, 9) and nameArray is (House, Chair, Table, Book). The function will return Chair.

Solved by F. A. in 24 mins