I am Trying to calculate Depreciation by straight line method. But I don't know which function to use.
It would be very nice if you me best method for calculation of the same.
Thank you in Advance
You can try the profile function. Check if that works in your case.
Profile function- https://help.anaplan.com/41b5fb84-395b-489f-80be-521add72c581-PROFILE
You can use the SPREAD function as well. It will distribute the value equally over the number of time periods you specify as the parameter.