if my labor rate is 0 to return 0 as the result.

Just to add another option (Excel 2007)

=IFERROR(A1/B1, 0)

= = = = = = =
Dana DeLouis

On 12/23/2009 4:10 PM, daviddm wrote:
I have a formula that divides the quantity in one cell by the quantity in
another cell to give me a result in a third cell. It's designed to give me
labor rates. The problem is if I have a particular item I don't need the rate
for it I type in 0. That give's me a#DIV/0 result. Is there a condition I can
use if my labor rate is 0 to return 0 as the result. The #div/0 screws up all
the other quantities I need.