Danny

Wrap it in an IF statement

=IF(A1="","",A1/B1)

or similar

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"danny boahn" wrote in message
...
how can i stop my worksheet from formula calculation until all the cells
for
the formula are filled