Value Equal Zero if Empty

  • Thread starter Thread starter Dave
  • Start date Start date
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]
 
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
 
Back
Top