MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting negative values to zero

Posted by M. Theriault on January 18, 2002 8:38 PM

I need a way to convert negative values in a interest
payment spreadsheet to zero so I can get an actual total
on the interest paid. Are there conditions that can be
built into a formula that can be carried through when
doing an autofill?

Posted by Chris D on January 19, 2002 2:38 AM

do you mean "if formula result < 0 then put 0, otherwise return the original formula result" ?

it would be something like this :

=if("your formula conditions"<0,0,"your formula conditions")

...depending on the complexity of the original formula and should be copyable via the autofill

Hope this gets you started

Posted by M.Theriault on January 19, 2002 7:30 AM

It works. Thanks for the help.