Can yo uexplain what this function is really doing. I think there are
errors in this formula and changing the function to VBA won't correct
the errors. the dependencies between the different input don't seem
correct.

Looking at the formula my first question is "Do you actually have
results less than 0?" If yoi udon't then you won't get most of the
conditions and the formula will simplify a lot.

Can you post a sample of the actual data? Seeing the data will give me
a chance to make a very simple formula that will be easier to maintain.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=182497

Microsoft Office Help