Net Price DIV Error

[quaidmason]

I am getting this pesky DIV error.

Columns are Price:Order: Free Goods : Total: Net

Easy One

$8.00: Order 2: No Free Goods: $16.00: $16.00

A little harder:
$8.00: Order 2: No Free Goods: $8.00: $8.00
$6.00: Order 0: 2 Free Goods: $0.00: $8.00 - 12.00 in free goods


keep getting div error since there is no order on the 6 dollar item. can send excel spreadsheet if needed.

Any help would be appreciated.

 

[Bill Rockenbach]

Check if divisor is zero
deviding cell a1 by cell b1
if cell b1 is zero null the cell
=IF(B1=0,"",A1/B1)