Report #DIV0! error help

[jhuillen]

I have this formula in a Text box for a report
And it works fine except if the field [Percent Complete] is zero it gives me
the division by zero error (#DIV0!) and it shows in the report how can I rewrite this formula so it will not show the error in the report?

=([Total of Hours Expended]/[Percent Complete]/100)*(100-[Percent Complete]*100)


Is there a IIf statment like in Excell to place zero as the value if there is a error?
like this!
IF(ISERROR(F18/H18/100),0,F18/H18/100*(100-H18*100)))

 

[JoeyY]

Yes

IIF([Percent Complete] = 0, 0, ([Total of Hours Expended]/[Percent Complete]/100)*(100-[Percent Complete]*100))

 

[jhuillen]

Great it works.
Thank you very much