Divide a cell by 2 and then add that together

[countrygirl0712]

I am trying to get an overtime rate to automatically calculate in an excel
spreadsheet. I want to take the hourly rate in one cell divide it by 2 and
then add the hourly rate to the rate I got by dividing and put that total
into another cell. Example: Cell G5 is hourly rate of $10.00. I want to
divide that by 2 which will give me $5.00. I want to add the $10.00 & $5.00
together giving me $15.00 and I want that to go into say cell K5. Does
anyone know how to do this?

[JE McGimpsey]

One way:

K5: =G5 * 1.5

In article <[email protected]>,
countrygirl0712 <[email protected]> wrote:

> I am trying to get an overtime rate to automatically calculate in an excel
> spreadsheet. I want to take the hourly rate in one cell divide it by 2 and
> then add the hourly rate to the rate I got by dividing and put that total
> into another cell. Example: Cell G5 is hourly rate of $10.00. I want to
> divide that by 2 which will give me $5.00. I want to add the $10.00 & $5.00
> together giving me $15.00 and I want that to go into say cell K5. Does
> anyone know how to do this?

[Bob Phillips]

=G5*1.5

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"countrygirl0712" <[email protected]> wrote in
message news:[email protected]...
> I am trying to get an overtime rate to automatically calculate in an excel
> spreadsheet. I want to take the hourly rate in one cell divide it by 2
and
> then add the hourly rate to the rate I got by dividing and put that total
> into another cell. Example: Cell G5 is hourly rate of $10.00. I want to
> divide that by 2 which will give me $5.00. I want to add the $10.00 &
$5.00
> together giving me $15.00 and I want that to go into say cell K5. Does
> anyone know how to do this?

[countrygirl0712]

I came into work this morning very anxious to try the formula and it worked
great. I put it in the cell that I wanted the answer in like this
=sum(k5*1.5) and it worked great. Thank you so much for your help.

"JE McGimpsey" wrote:

> One way:
>
> K5: =G5 * 1.5
>
> In article <[email protected]>,
> countrygirl0712 <[email protected]> wrote:
>
> > I am trying to get an overtime rate to automatically calculate in an excel
> > spreadsheet. I want to take the hourly rate in one cell divide it by 2 and
> > then add the hourly rate to the rate I got by dividing and put that total
> > into another cell. Example: Cell G5 is hourly rate of $10.00. I want to
> > divide that by 2 which will give me $5.00. I want to add the $10.00 & $5.00
> > together giving me $15.00 and I want that to go into say cell K5. Does
> > anyone know how to do this?
>

[countrygirl0712]

I came into work this morning very anxious to try the formula and it worked
great. I put it in the cell that I wanted the answer in like this
=sum(k5*1.5) and it worked great. Thank you so much for your help.


"Bob Phillips" wrote:

> =G5*1.5
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "countrygirl0712" <[email protected]> wrote in
> message news:[email protected]...
> > I am trying to get an overtime rate to automatically calculate in an excel
> > spreadsheet. I want to take the hourly rate in one cell divide it by 2
> and
> > then add the hourly rate to the rate I got by dividing and put that total
> > into another cell. Example: Cell G5 is hourly rate of $10.00. I want to
> > divide that by 2 which will give me $5.00. I want to add the $10.00 &
> $5.00
> > together giving me $15.00 and I want that to go into say cell K5. Does
> > anyone know how to do this?
>
>
>

[JE McGimpsey]

Note that the SUM() in your formula is not necessary, simply applying a
another function to the value returned by k5*1.5, returning the same
value.


In article <[email protected]>,
countrygirl0712 <[email protected]> wrote:

> I came into work this morning very anxious to try the formula and it worked
> great. I put it in the cell that I wanted the answer in like this
> =sum(k5*1.5) and it worked great. Thank you so much for your help.

[Bob Phillips]

No need for SUM, nothing is being summed so it is superfluous.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"countrygirl0712" <[email protected]> wrote in
message news:[email protected]...
> I came into work this morning very anxious to try the formula and it
worked
> great. I put it in the cell that I wanted the answer in like this
> =sum(k5*1.5) and it worked great. Thank you so much for your help.
>
>
> "Bob Phillips" wrote:
>
> > =G5*1.5
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "countrygirl0712" <[email protected]> wrote in
> > message news:[email protected]...
> > > I am trying to get an overtime rate to automatically calculate in an
excel
> > > spreadsheet. I want to take the hourly rate in one cell divide it by
2
> > and
> > > then add the hourly rate to the rate I got by dividing and put that
total
> > > into another cell. Example: Cell G5 is hourly rate of $10.00. I
want to
> > > divide that by 2 which will give me $5.00. I want to add the $10.00 &
> > $5.00
> > > together giving me $15.00 and I want that to go into say cell K5.
Does
> > > anyone know how to do this?
> >
> >
> >

[countrygirl0712]

Okay, thanks again.

"JE McGimpsey" wrote:

> Note that the SUM() in your formula is not necessary, simply applying a
> another function to the value returned by k5*1.5, returning the same
> value.
>
>
> In article <[email protected]>,
> countrygirl0712 <[email protected]> wrote:
>
> > I came into work this morning very anxious to try the formula and it worked
> > great. I put it in the cell that I wanted the answer in like this
> > =sum(k5*1.5) and it worked great. Thank you so much for your help.
>

[countrygirl0712]

Thank you very much.

"Bob Phillips" wrote:

> No need for SUM, nothing is being summed so it is superfluous.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "countrygirl0712" <[email protected]> wrote in
> message news:[email protected]...
> > I came into work this morning very anxious to try the formula and it
> worked
> > great. I put it in the cell that I wanted the answer in like this
> > =sum(k5*1.5) and it worked great. Thank you so much for your help.
> >
> >
> > "Bob Phillips" wrote:
> >
> > > =G5*1.5
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (remove nothere from email address if mailing direct)
> > >
> > > "countrygirl0712" <[email protected]> wrote in
> > > message news:[email protected]...
> > > > I am trying to get an overtime rate to automatically calculate in an
> excel
> > > > spreadsheet. I want to take the hourly rate in one cell divide it by
> 2
> > > and
> > > > then add the hourly rate to the rate I got by dividing and put that
> total
> > > > into another cell. Example: Cell G5 is hourly rate of $10.00. I
> want to
> > > > divide that by 2 which will give me $5.00. I want to add the $10.00 &
> > > $5.00
> > > > together giving me $15.00 and I want that to go into say cell K5.
> Does
> > > > anyone know how to do this?
> > >
> > >
> > >
>
>
>