ignore negitive numbers

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

Guest

I am making up a mortgage sheet. I have all the formulas
inserted and it all works great except when i want to make
up a payment shedule. I made up the first line of the
shedule and then draged the fill down till the last
balance reached zero.

Now my problem is when I want to redo the sheet to use
different numbers then i could end up with negitive
numbers on the sheet.

I was thinking one way of dealing with this is to have
excell hide and ignore negitive numbers. Is this possible?

I am using the sum formula to sum up a column for total
payments and the same thing to total interest payments.

any help apreciated!
 
Maybe one acceptable way:

=IF(YourFormula<0,0,YourFormula)

For example:

=IF(A2-B2<0,0,A2-B2)

Regards

Trevor
 
max(0;YourFormula)
or simply a userdefined format like #'##0.00;"" where the part after the
first ; is relevant.
 
or simply a userdefined format like #'##0.00;"" where the part after the
first ; is relevant.
Click to expand...

The custom format will hide the negative value but if it is referenced by
other cells then the negative value will still be used.

Regards

Sandy
 
Back
Top