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

[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?

 

[Dave Peterson]

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.

 

[Guest]

try ," ", instead of , , for the true part

 

[Guest]

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

 

[Don Guillett]

try this idea. You may? want a74 to be $a$74
=IF(e8*d9>=a74,"",a74+1)