You are close....

C4: is a price
D4: may have a quantity or may be blank
E4: is a price
F4: may have a quantity or may be blank
G4: Subtotal to reflect whether D4 or F4 has a qty * the respective price

"Tim C" wrote:

If I am understanding you correctly:

C4: may have a quantity or may be blank
D4: may have a quanitity or may be blank
E4: price each
F4: total

In F4, use:
=(C4+D4)*E4

Tim C

"julescc" wrote in message
...
Does anyone know how I can write a formula for a sales order sheet that I
am
creating that will allow me to insert a quantity in one of two
column/cells
and have a subtotal cell read between those two quantity cells and have
the
formula place the correct quanity to the respective price in the subtotal
field?

Thanks!
--
Jules