to prevent UDF calculation Range is empty

[daboho]

i have UDF for sum (A2-A1)+(A3-A2)+(A4-A3) + ... So on
when i am select =adc(A1:A5) result is true
but while 1 am select adc(A1:A11) result not correct
A1:A11 is empty
i has to use if for prevent calculation but not sukses
help me every body

Please Login or Register  to view this content.

res.png
IN this picture result 40 is true but result -10 not true

[MrShorty]

Is this the actual calculation, or is this an attempt at something that you feel is representative? Some simple algebra on that expression should show you that sum(for i= 1 to n-1)(a(i+1)-a(i)) simplifies to a(n)-a(1) [50-10 in the example]. Assuming your example is representative, I would be tempted to do away with the UDF and do something like =INDEX($A$1:$A$11,COUNT($A$1:$A$11)-$A$1

[daboho]

it is only sample my number is variant i want to prevent empty data

[MrShorty]

I don't understand your response.

If this is not the actual calculation you are using, I suggest that you provide a sample of the actual calculation.

If this is the actual calculation, but you are working with varying numbers of entries, I don't understand why the simpler, non-VBA formula I provided wouldn't work, as it is designed to handle varying numbers of entries in A1:A11.

[xlnitwit]

I can't see the point either, but perhaps

Please Login or Register  to view this content.