#div/0 help

Can anyone help me??

i have this formula =(D6-E6)/E6 which works out the percentage in a workbook, but if i have a zero in the cell it gives me #div/0. im not sure how to write the formula with the if function to remove the #div/0

any help would be greatly appreicated.

Try either..

=IFERROR((D6-E6)/E6,"")

or

=IF(E6=0,"",(D6-E6)/E6)

Thank you works perfect, thanks so much.

You're welcome.