Round function

[nguyenal07]

=((INDEX(Target!$A$1:$J$52,MATCH(1,(Target!$A$1:$A$52=A5)*(Target!$B$1:$B$52=A3),0),MATCH("PriorYearAvg",Target!$A$1:$J$1,0))-(INDEX(Target!$A$1:$J$52,MATCH(1,(Target!$A$1:$A$52=A5)*(Target!$B$1:$B$52=A3),0),MATCH("Target Steps",Target!$A$1:$J$1,0))*MONTH($C$2)))/4)

I am having trouble adding the round function to the function above..

any help would be greatly appreciated it..


thanks

[boopathiraja]

May be try something like this, else post a sample file

Please Login or Register  to view this content.