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]
=nz([Time and Hours].[Form]![Text95]/2*[Combo351],0) should do it.

grep
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top