I've got a problem with an Excel formula I'm working on.

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

Guest

I am trying to correct a formula I'm entering on Excel. The formula is:
=If(A74=E8*E9, ,If(A74<E8*E9,A74+1)); with E8=5, E9=12, and A74=60. The
result I am getting is "0", and the result I want is a blank cell. I am
trying to produce a loan amortization table where one can vary the amounts
and length of the notes. In this case, E8 is the number of years, E9 is the
number of payments within a year, and Column A is the payment number. I'm
trying to make it where after 60 months in this case, I'll get empty cells
instead of cells with "0" in them. Can you help me?
 
Maybe:

=IF(A74=E8*E9,"",IF(A74<E8*E9,A74+1,""))

This makes the cell look blank, but the cell is not empty. It contains the
formula.
 
Hi Bill,
You'll need to put in "" rather than leaving blank:
=If(A74=E8*E9,"" ,If(A74<E8*E9,A74+1))
If you do need to leave that bit blank, you can hide zero's in Tools/Options
and untick 'zero values'

hth
 
Back
Top