| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Writing a formula
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
=C4*D4+E4*F4
Tim C "julescc" wrote in message ... 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 |
|
#7
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| I need help writing a formula. | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| Trouble writing an excel formula... | Excel Worksheet Functions | |||
Linear Mode
