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
Chris

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

It works. Thanks for the help.