Use a if statement

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Andres A" wrote in message ...
I'm trying to zero out the value in a cell if the formula evalutes to an
error but keep the value if it's not error.