Not sure if I did this correctly but it came up with a zero value =IF
(ISNUMBER($E$4:$E$103),LN($E$4:$E$103)) - entered as an array formula,
correct? This is the X range. It represents the number of units in sequential
order. So that the range is a possible 100 vaules and I currently have 1 - 82
in the range. The rest or the range are true blank cells.

Jerry W. Lewis wrote:
Instead of
LN(range)
use
If(ISNUMBER(range),LN(range))
and array enter the formula.

Jerry

Thanks and sorry I should have been clear in defining my issues. I have
reposted the issue under Dynamic Range Name in Functions. It's true the
[quoted text clipped - 16 lines]
Thank you in advance for any asssistance.
Carrie

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200808/1