If you save it as a named function you can add a comment and that will appear as the tooltip while you're working on calling the function. If you're just wanting to comment how/why the function works in the cell you're defining or instantiating and immediately using it Excel has comments and notes you can attach to the cell or a group of cells.