blank cells in calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Adding recognised Zeros 5
Calculation / Format Error 1
Average formula where blank cells are counted as zeros 4
Blank Cells vs. Zero Values 2
Is use of XIRR appropriate when dividends are not reinvested? 2
=IF(ISERROR(GB18-FC18),"",(GB18-FC18)) returning zero instead of b 2
Counting blanks as zeros 1

Back
Top