hi,

I was wondering if there is any way to apply an IF statement, such as If(a4<d38,"0",X); whereas X= what is already contained in the cell, to a large array of cells, say d40:AY900, that already contain somewhat complicated formulas//data, such that you can apply a conditional that would override anything else that is there, without having to go into each individual cell (since there are so many, all of which contain important data//formulas which would be relevant if this one case is not met) and individually typing the conditional in front of the pre-existing formulas....