Writing a formula

[julescc]

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!

 

[Tim C]

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]

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

 

[Joe S.]

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

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

 

[Joe S.]

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

 

[Tim C]

=C4*D4+E4*F4

Tim C

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

 

[julescc]

Your formula worked Joe - thanks! It did exactly what I needed it to!