REPLACE

[Jane]

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!)

 

[Biff]

Hi!

Are the values in those cells manually entered? To do what
you want requires that each of those cells has a formula
in it. But, at the same time you can't also manually enter
hard coded values in them. You can either have a formula
or a hard coded value but not both.

You could do something like this in each of the cells.

For example, in cell B1:

=IF(A1=0,100,50)

Meaning: if A1 = 0 then the value in cell B1 is 100
otherwise, it's 50.

Biff

 

[tpmax]

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