Can you post a copy of your spreadsheet? Otherwise, update your original post with additional data, including:

What cells/columns are referenced by cost avoidance, market price, line amount, list price, unit price, etc.. And what does 'replace all -ve values' mean??

A nested IF statement may be possible, but you're testing a bunch of things that don't seem related in my mind. Seeing it would probably help.