Divide two number

[barkarlo]

I must divide income from 2007 and 2006. but in same cases income in 2006 is null and result is #error. How can I see 0 for this case.
for an example 120/0=0

[abolos]

I must divide income from 2007 and 2006. but in same cases income in 2006 is null and result is #error. How can I see 0 for this case.
for an example 120/0=0

If text0.text is Null then tex0.value=0

[barkarlo]

If text0.text is Null then tex0.value=0

I have a query with columns:
income2007, income2006 IND07/06.
In column IND07/06 i have formula
=nz([income2007];0)/iif(nz([income2006];0)=0;1;[income2006]))*100.
if income2006=0 this formula return result, but I want see result 0 for this cases.

[Rabbit]

Replace your semicolons with commas.

[barkarlo]

Replace your semicolons with commas.

now is OK.
Thank you

[Rabbit]

Not a problem, good luck.