**********
You can generally get around this type of hurdle with an IF statement:
for instance
=IF(Assumptions!AB18=0,"",1/Assumptions!AB18)
This returns a blank if AB18 equals zero, and performs the division if
AB18 is not zero.

Can you use that logic to flow through the various calculations in your

sprdsht?
***********

Unfortunately not. Having it display a blank is recognized by excel,
which then in turn causes the other cells to display a #VALUE error.

***********
Hi,

You could use something like


=IF(ISERROR(C10),"",$A10*D$3,($A10-((D10/2)*$A10))*D$3)


This will give you a blank in case C10 is #DIV/0

Regards,
Bondi
**********
Much appreciated but unfortunately the formula does not work - too many
arguements.