On Mar 27, 1:23 pm, "Jenny" wrote:
Sorry, I mean" I need formula that
it will automatically shows most recent 3 months evaluate result"

I added a column to the right of the "evaluate" column and entered the
formula
=ADDRESS(2,MATCH(TRUE,A2:L2="",0),4) (enter as array formula CTRL-
SHIFT-ENTER)
Then, in the "evaluate" column, I put the formula
=IF(AND(ABS(OFFSET(INDIRECT(N2),0,-3)-1)0.15,ABS(OFFSET(INDIRECT(N2),
0,-2)-1)0.15,ABS(OFFSET(INDIRECT(N2),0,-1)-1)0.15),"over","normal")

This will cause an error if there are less than 3 cells to reference.
You can enter the "evaluate" formula as a named range (myFormula) then
use the formula
=IF(ISERROR(myFormula),"< 3 months",myFormula)

I hope that helps.