Calculate value problem

[isv_2004]

I cannot figure this out,

I have values that need to be calculated in a field but it will not work with null values, I’m sure this is easy but I have not found a solution.

Thanks in advance.

The attached mdb illustrates my dilemma.

 

[RuralGuy]

Have you looked at the Nz() function?