KimberlyC wrote...
....
Is there a formula that I can enter into cell C15 of the "Ajust"
worksheet
that will show zero if the "Additons" worksheet does not exist ....and
if
the worksheet does exists, then have the formula reference the total
in cell
Q30 fo the "Additons" worksheet??
=IF(ISERROR(CELL("Address",Additions!Q30)),0,Addit ions!Q30)
This will pass through error values in Additions!Q30 (if any), which is
a good thing, while evaluating to zero if the Additions worksheet
doesn't exist.
|