Desktop

Ask something
Discussion Locked

EXCEL CUSTOMIZED FUNCTION

0 helpful
3 replies

by chitosunday

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I created an excel function which computes the payback of an investment. The function works well. However, i want to give a description of the
function and the purpose of each cell or range like the usual functions of excel. Formula is =payback(investment cell, cashinflow rangeA, cashflow rangeB)where inputs for investmentcell and rangeA are mandatory and rangeB is optional.

3 replies

by dklippert

This can be done, but not as easily as we would like.
Laurent Longre has this solution:

http://tinyurl.com/fmvu

http://tinyurl.com/fmwm

This discussion is closed to new replies.