Calculation with a null value

[SDDiamonds]

I am working with a modified "Orders Entry" Database and
I need to have the Line Total = carat weight (if any) *
Quantity * Unit Price (for diamonds this is the "per
carat price") - Discount. However - If it's a piece of
jewelry there is no Carat Weight - which throws off my
calculations. . .how do I tell it to ignore the cell if
there is no value in it.

 

[Kevin Sprinkel]

See VBA Help on the NZ function, which returns a value of
zero if the field is null, or another value of your
choosing.

HTH
Kevin Sprinkel