How to convert an Excel formula from SSRS report

Posted By Posted by: Ahmed Taee on October 25, 2016

Blog_Blue Bar Skinny

In your report, create a field that will be a formula field when the report is exported to Excel.

In the example below, the cell underneath Results column header will be the summation of First Value plus Second Value.



The expression content will be “=C3+D3”


Run the report and export it to Excel


To convert it to an Excel formula, go to cell B3, Press F2 and click Enter


Hope this works for you!

Blog Posted In Blog Posted In: Blog, How to, Reporting, Uncategorized
Blog Posted In 

Leave a Reply

Your email address will not be published.