I've created two calculation ( 1. pension payable, given age, salary and years of service and 2. lump sum payable which is 3 x pension).


If the employee is under the Normal Retirement Age (say age 60 for example), I want excel to calculate the early retirement amounts and to input them in a block of text on sheet 2 and then to merge the whole block of text into an existing letter (yes I've done a letter on excel to make things easier for me) on sheet 1.

Is what I'm after possible???

Thanks

James.