Hi all,

Trying to set up a couple of UDF's but having problems with the fidgity bits!!

First one.. Nice easy one to start with!!

In the spreadsheet the formula is as follows =SUM(A1:A5)/5

The ?? Is the bit I can't figure out, how do apply the range A1:A5 to i ??

[VBA]

Function FMA(i)

??

FMA = WorksheetFunction.Sum(i) / 5

End Function

[/VBA]

And the second one, blimey

Sharp intake of breath...

I'm trying to acheive

RSI=100-100/(1-A/B)

A refers to the average of up days in a given period.

B refers to the average of down days in a given period

So say there are 5 up days in the period which is 10 days.

The up days are for example 13, 14, 56, 37, 2. These then need to

be added and stored in A

Likewise, we have 5 down days eg 40,67, 34,12,4. Again these all

need to be added to B

So what needs to happen is for the spreadsheet to recognise when there

is an upday from the previous day, or when there is a down day compared

to the previous day, tall those up and include them in the A & B ??

Hope that makes some kinda sense??

Thanks in advance for any advice you can offer