can i put a formula to stop div/0 in the formula cells
should there be no data in the cells making up the data?

thanks for your help

rob

rob wrote:
can i put a formula to stop div/0 in the formula cells
should there be no data in the cells making up the data?

thanks for your help

rob

Certainly. try +IF(A1=0,"",A2/A1)

Thank you


-----Original Message-----
can i put a formula to stop div/0 in the formula cells
should there be no data in the cells making up the data?

thanks for your help

rob
.