Your formula worked Joe - thanks! It did exactly what I needed it to!
"Joe S." wrote:
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
|