Cell Formula

[nick]

I try to use the grid to insert this formula:

=ROUND(INTERCEPT(A1:A5,B1:B5),3) but no execute calculation.

I can't use more functions in a cell. Why?

Regards

Nick

[Rajasekar]

Hi Nick,

Thanks for using Syncfusion products.

We checked with your requirement, We found that In our sample Multiple Functionality is working fine.

We have checked with the multiple functions in the Excel Grid Control.

For instance, multiple functions like below,

1. =ROUND(INTERCEPT(A1:A5,C1:C5),3)
2. =SUM(A1,A5)
3. =AVERAGE(A1:A5)*AVERAGE(C1:C5)
4. =SLOPE(A1:A5,B1:B5)

We have also created the sample for your reference, please find the sample in the following location,

Sample:ExcelLikeDemo_SL398718234.zip

Please let us know if you have any queries.

Thanks,
Rajasekar