Put this in E2 and copy it down column E........

=IF(AND(D20,D2<100),A2,"")

Vaya con Dios,
Chuck, CABGx3


"les8" wrote:

I have a list of stores that have goals each month.
(store # is in col a, actual sales in col b, goal sales in col c,
actual-goal in col d

I want it to do the following:
if(and(col d0,col d<100)col a,"")
Once it has evaluated that line, I want it to go to the next line and do the
same thing.

Is there a way to do this?

Thank you.