Value Equal Zero if Empty

D

Dave

I need this code to show 0 if no there is no value to the formula, it is in
a currenct format. i.e. $0.00

=[Time and Hours].[Form]![Text95]/2*[Combo351]
 
G

grep

Dave said:
I need this code to show 0 if no there is no value to the formula, it is in
a currenct format. i.e. $0.00

=[Time and Hours].[Form]![Text95]/2*[Combo351]
Click to expand...
=nz([Time and Hours].[Form]![Text95]/2*[Combo351],0) should do it.

grep
 
Top