need to mark up 16800 items by 15% column e is my net and need column f
with new prices

Hi,
in column F enter

=E2*1.15

copy formula down

you can have a cell where you enter the markup % like A1, then have F
calculate it using

=E2*(1+A1)

in A1 you will enter 15

"arKwelder" wrote:

need to mark up 16800 items by 15% column e is my net and need column f
with new prices

opps you will enter 0.15 instead of 15


"Eduardo" wrote:

Hi,
in column F enter

=E2*1.15

copy formula down

you can have a cell where you enter the markup % like A1, then have F
calculate it using

=E2*(1+A1)

in A1 you will enter 15

"arKwelder" wrote:

need to mark up 16800 items by 15% column e is my net and need column f
with new prices

.... and you may want =E2*(1+A$1) instead of =E2*(1+A1), if you are going to
copy down.
--
David Biddulph


"Eduardo" wrote in message
...
opps you will enter 0.15 instead of 15


"Eduardo" wrote:

Hi,
in column F enter

=E2*1.15

copy formula down

you can have a cell where you enter the markup % like A1, then have F
calculate it using

=E2*(1+A1)

in A1 you will enter 15

"arKwelder" wrote:

need to mark up 16800 items by 15% column e is my net and need column
f
with new prices