Formula not calculating when field is null

[hunterfan48]

Here's my formula.

=[Price]+[Shipping]-[Fees]-[Shipping Costs]

Why isn't it calculating when one of the fields is left blank?

Thank you in advance!

 

[ByteMyzer]

When you attempt to perform a mathematical calculation on one or more expressions, and any one or more of those expressions is null, the calculation will fail.

Try:

=Nz([Price],0)+Nz([Shipping],0)-Nz([Fees],0)-Nz([Shipping Costs],0)

 

[hunterfan48]

Perfect...thank you so much!