We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
Download and install the [latest release] 1. You don't need to be Administrator and there's no configuration required.
Open an Excel spreadsheet, select a cell and type =R.sum(1,2).
=R.sum(1,2)
That's pretty much it -- you are calling R from Excel. Of course that's not a particularly useful function; read on to add your own functions.
Click the Excel ADD-INS tab, and click Home Directory. This will pop up a directory window showing the BERT install directory.
Open the file "functions.R" in your favorite code editor. Write a new function:
my.func <- function( a, b ){ a+b }
and save the file.
On the ADD-INS tab, click Reload Startup File. That will update Excel with your new function.
Select a spreadsheet cell and type =R.my.func( 3, 4 ).
=R.my.func( 3, 4 )