ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - div (https://www.excelbanter.com/new-users-excel/4850-div.html)

rob

div

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

Gordon

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)

rob

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
.

All times are GMT +1. The time now is 02:17 AM.