I am using Excel from Office 2007.

I transfered a spreadsheet program from a Works spreadsheet, which I had
adapted from one supplied with the program. It calculates your mortgage
payments. I adapted it to calculate ROI from several variables on prespective
rental properties.

In Excel I get a #VALUE error when a cell conditionally references another
cell that references another cell.

I have attached several of the cell functions.
=IF(AND(F5,F6,F7),PMT((F6/12)/100,F11,-F5),"")

=IF(AND(G8,G9,G10),PMT((G9/12)/100,G13,-G8),"")

=IF(G24,G24/G5,"")

The online help says that I shouldn't reference a function, but I need the
return of that cell's function to complete another function in another cell.

The cell may return my monthly mortgage payment. I then use that product and
the product of say property taxes/12, management fees and yearly repair
expenses/12 to calculate my estimated monthly expenses on a property. I can
then calculate my free cash flow from that property for the month.

If the cell referenced is blank, I'd like the cell referencing it to remain
blank too.

The spread sheet seems to work properly when the variable cells are filled,
but I want the cells doing a calculation to remain blank if there are no
values in the other cells.

If someone can also point me to where I can read more extensively on the
matter, I would be most grateful.

--
YMHS

Radar