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 ??
nCode:Function FMA(i)
??
FMA = WorksheetFunction.Sum(i) / 5
End Functio
And the second one, blimey :banghead:
Sharp intake of breath...
I'm trying to acheive
A refers to the average of up days in a given period.Code:RSI=100-100/(1-A/B)
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 :clap: