ExcelBanter - blank cells in calculations

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - blank cells in calculations (https://www.excelbanter.com/excel-worksheet-functions/33906-blank-cells-calculations.html)

Cliff

blank cells in calculations

I am attempting to calculate returns for approximately 250 investment
accounts that have been around for different lengths of time. I am copying
the same XIRR formula accrossed all 250 accounts. The problem is that the
blank cells are counted as zero's - is there any way to not count the blank
cells as zero's?

Jerry W. Lewis

Use an IF() function.

Jerry

Cliff wrote:

I am attempting to calculate returns for approximately 250 investment
accounts that have been around for different lengths of time. I am copying
the same XIRR formula accrossed all 250 accounts. The problem is that the
blank cells are counted as zero's - is there any way to not count the blank
cells as zero's?

All times are GMT +1. The time now is 06:03 AM.