Aspose.Cells deals with shared formulas quite well. However, kindly provide us your expected excel file which you can create manually using Microsoft Excel. We will then look into your expected file and let you know how to apply your formula using Aspose.Cells APIs. Thanks for your cooperation in this regard and have a good day.