This assumes that there will be only one quantity (i.e., value in either C4
or D4, not both).

"Joe S." wrote:

Try
=IF(ISNUMBER(D4),C4*D4,E4*F4)

If there is not a number in either C4 or E4, the result will be 0.

"julescc" wrote:

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