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

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" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >

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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
> > >
> > >
> > >

=C4*D4+E4*F4

Tim C

"julescc" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>>

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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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
> > > >
> > > >
> > > >