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
-----Original Message-----
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!)
.
|