Calculation with a null value

S

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.
 
K

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
 
Top