Limited expectation of lognormal and pareto

Hello,



I am working on a project of calculating ILF for P&C business by curve-fitting. I was wondering where I can find the the limited expectation formulea for those two distributions. Or are there any functions in Excel that can generate those limited expectation if we input the parameters for those two distribution function.





Thanks.

Limited expectation of lognormal and pareto