if formula help please!!

[The Simeons]

Can ne1 help me with a formula please.

I have a payment shedule which shows how much people have paid off a certain
amount. I want the columns underneath to show a "0" value if the amount
outstanding is above 1. Cna ne1 help please. TY

 

[Norman Harker]

Hi!

You'll have a normal formula that keeps track of the balance. So you
just need to modify:

=IF(CellAbove=0,0,IF(CellAbove>1,0,NormalFormula))

The nested IF function returns 0 if the cell above is greater than
zero. The trouble is that in the next cell the 0 will read as not >1.
That's why we nest it in another IF function that returns 0 if the
cell above is already zero.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.