What does this function means?

[nguyenal07]

=((VLOOKUP(A5,Target!$A:$N,MATCH("PriorYearAvg",Target!$A$1:$N$1,0),0))-(((VLOOKUP(A5,Target!$A:$N,MATCH("Target Steps",Target!$A$1:$N$1,0),0)))*MONTH(C2)))/4


from what im reading this function is using A5 to scan for identical field from the target sheets.

Putting it in math terms:

(Taking the PriorYearAvg - Target Steps) *CurrentMonths number/4??

I think im reading it wrong because the result of my formula is different from what i translated myself.

Please advise.

Thanks

[Speshul]

Broken in hals at the red MINUS sign
=((VLOOKUP(A5,Target!$A:$N,MATCH("PriorYearAvg",Target!$A$1:$N$1,0),0))-(((VLOOKUP(A5,Target!$A:$N,MATCH("Target Steps",Target!$A$1:$N$1,0),0)))*MONTH(C2)))/4

=((VLOOKUP(A5,Target!$A:$N,MATCH("PriorYearAvg",Target!$A$1:$N$1,0),0))-

It is looking on the Target tab at Column A for a value matching A5. It is returning the "PriorYearAvg" column for the row matching the value in A5.

---------------------------

(((VLOOKUP(A5,Target!$A:$N,MATCH("Target Steps",Target!$A$1:$N$1,0),0)))*MONTH(C2)))/4

It is then looking for A5 in that same Target!$A:$N are and bringing back the value in the Target Steps column on the row A5 is found. It is multiplying that value by the Month Number in the date in C2, then dividing by 4. The resulting value is subtracted from result of the first part of the formula

[nguyenal07]

for example if the prior year avg = to 785.58 and target steps =32.7325 month =8

What I did was

(785.58-32.7325) *8 =6022
then 6022/4 = 1505

Is that inccorect because the formula answer gave me 172

maybe i dont understand the formula complete...thanks for your help

[aspie]

I have a Learning difficulty called Dyscalculia, this is basicaly the number form of dyslexia, and I have a servere form of it so I can not do basic maths with out a calculator. But just looking at the numbers given (784.58 -32.7325) *8 -6022 THAN 6022/4 - 1505
I can see how that would probibly be a three digit figure.

[protonLeah]

Notice that:
1. (Taking the PriorYearAvg - Target Steps) *CurrentMonths number/4
Is not the same as:
2. ((Taking the PriorYearAvg - Target Steps) *CurrentMonths number)/4

In #1 (your translation) you are multiplying the difference by one fourth of the current month's value..
In #2, the original, the difference is multiplied by the current month's value and the resulting product divided by four.