Sounds like you need to use an IF statement in cells B1, C1, D1, E1 and F1.

"Jane" wrote:

need to replace values in cells B1, C1, D1, E1, and F1 IF A1 =0

thank you in advance! jane (again ) :( been one of THOSE days!)