To use the IRR Function in Google Sheets Calculating IRR for an Investment: Write the IRR function in a cell. The formula in cell D2 ...