Hi

I'm glad it helped.

Actually, I was trying to use (C2*-1) to avoid having a -ve in the INV cell.... if you know of a way to do that it wd make my spreadsheet look a little better
For ex. 3 options:

- if you just want to make the spreadsheet look better, format the cell to display negative numbers as positive numbers. The value of the cell will still be negative but anyone looking at the worksheet sees it as positive. You must, however, remember always to enter the INV value as negative. In this case you don't have to change the formula.

- if you really want to enter the value of INV as positive, you can use a formula to generate an array where you change the sign of the INV value.

- you could also use vba and write a udf with the INV and NP ranges as input

The first option is the simplest.