I have no idea how to do this or if it's possible but I've been at this for
hours and am at a loss. I have 15,000 cells in one column that all have to
have different percentage mark ups. For instance the entire column is a
"wholesale" price. Certain items need to be marked up 50% others 40% and
others 75%. All groups are together in the colum so for instance cells 1-280
need to be marked up 50%, cells 281-900 need to be marked up 40%, and cells
901-3400 need to be marked up 75% and so on. How can I highlight the cells
and do a simple mark up without having to get a calculator out and
calculating what $2 plus 50% mark up is or $15.75 plus 40% mark up is
manually?

Hi,

Do it in several steps and for the first markup of 50% try this. Put 1.5 in
a cell and copy it. Select rows 1 to 208 and right click them, click 'paste
Special' select 'Multiply' and then OK.

Repeat for other markups
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"autiemomtoo" wrote:

I have no idea how to do this or if it's possible but I've been at this for
hours and am at a loss. I have 15,000 cells in one column that all have to
have different percentage mark ups. For instance the entire column is a
"wholesale" price. Certain items need to be marked up 50% others 40% and
others 75%. All groups are together in the colum so for instance cells 1-280
need to be marked up 50%, cells 281-900 need to be marked up 40%, and cells
901-3400 need to be marked up 75% and so on. How can I highlight the cells
and do a simple mark up without having to get a calculator out and
calculating what $2 plus 50% mark up is or $15.75 plus 40% mark up is
manually?

Ok maybe I kind of didn't make it clear, sorry. for instance cells 1-208
have all different numbers 2, 15.25, 18., 5, 3, 3.75, 6, 19.99, 22.25, 2.5,
2.75) each number represents a price and each of these prices have to be
marked up by let's say 40%. Not all of the cells are $2.00. the 208 cells
have 208 different prices that need to be marked up 40%. Then cells 209-500
in that colum have all different prices that need to be marked up 75%. So
whatever is in that cell needs to be "plus" whatever percent i need it to be.
I have no idea how to highlight 208 cells of all different prices and make
excel say "add 40%".

"Mike H" wrote:

Hi,

Do it in several steps and for the first markup of 50% try this. Put 1.5 in
a cell and copy it. Select rows 1 to 208 and right click them, click 'paste
Special' select 'Multiply' and then OK.

Repeat for other markups
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"autiemomtoo" wrote:

I have no idea how to do this or if it's possible but I've been at this for
hours and am at a loss. I have 15,000 cells in one column that all have to
have different percentage mark ups. For instance the entire column is a
"wholesale" price. Certain items need to be marked up 50% others 40% and
others 75%. All groups are together in the colum so for instance cells 1-280
need to be marked up 50%, cells 281-900 need to be marked up 40%, and cells
901-3400 need to be marked up 75% and so on. How can I highlight the cells
and do a simple mark up without having to get a calculator out and
calculating what $2 plus 50% mark up is or $15.75 plus 40% mark up is
manually?

Hi,

The answer is the same. say we have these values in a1 to a5

2
3
4.8
8.2
5

I put 1.4 in another cell and copy it. Select these numbers and right
click|Paste special|Multiply Ok, the numbers become

2.8
4.2
6.72
11.48
7

i,e all have been marked up by 40%
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"autiemomtoo" wrote:

Ok maybe I kind of didn't make it clear, sorry. for instance cells 1-208
have all different numbers 2, 15.25, 18., 5, 3, 3.75, 6, 19.99, 22.25, 2.5,
2.75) each number represents a price and each of these prices have to be
marked up by let's say 40%. Not all of the cells are $2.00. the 208 cells
have 208 different prices that need to be marked up 40%. Then cells 209-500
in that colum have all different prices that need to be marked up 75%. So
whatever is in that cell needs to be "plus" whatever percent i need it to be.
I have no idea how to highlight 208 cells of all different prices and make
excel say "add 40%".

"Mike H" wrote:

Hi,

Do it in several steps and for the first markup of 50% try this. Put 1.5 in
a cell and copy it. Select rows 1 to 208 and right click them, click 'paste
Special' select 'Multiply' and then OK.

Repeat for other markups
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"autiemomtoo" wrote:

I have no idea how to do this or if it's possible but I've been at this for
hours and am at a loss. I have 15,000 cells in one column that all have to
have different percentage mark ups. For instance the entire column is a
"wholesale" price. Certain items need to be marked up 50% others 40% and
others 75%. All groups are together in the colum so for instance cells 1-280
need to be marked up 50%, cells 281-900 need to be marked up 40%, and cells
901-3400 need to be marked up 75% and so on. How can I highlight the cells
and do a simple mark up without having to get a calculator out and
calculating what $2 plus 50% mark up is or $15.75 plus 40% mark up is
manually?

yes! thank you so much.... if it is supposed to be 100% mark up or 110% mark
up what is it multiplied by? would 110% be 2.1?

"Mike H" wrote:

Hi,

The answer is the same. say we have these values in a1 to a5

2
3
4.8
8.2
5

I put 1.4 in another cell and copy it. Select these numbers and right
click|Paste special|Multiply Ok, the numbers become

2.8
4.2
6.72
11.48
7

i,e all have been marked up by 40%
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"autiemomtoo" wrote:

Ok maybe I kind of didn't make it clear, sorry. for instance cells 1-208
have all different numbers 2, 15.25, 18., 5, 3, 3.75, 6, 19.99, 22.25, 2.5,
2.75) each number represents a price and each of these prices have to be
marked up by let's say 40%. Not all of the cells are $2.00. the 208 cells
have 208 different prices that need to be marked up 40%. Then cells 209-500
in that colum have all different prices that need to be marked up 75%. So
whatever is in that cell needs to be "plus" whatever percent i need it to be.
I have no idea how to highlight 208 cells of all different prices and make
excel say "add 40%".

"Mike H" wrote:

Hi,

Do it in several steps and for the first markup of 50% try this. Put 1.5 in
a cell and copy it. Select rows 1 to 208 and right click them, click 'paste
Special' select 'Multiply' and then OK.

Repeat for other markups
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"autiemomtoo" wrote:

I have no idea how to do this or if it's possible but I've been at this for
hours and am at a loss. I have 15,000 cells in one column that all have to
have different percentage mark ups. For instance the entire column is a
"wholesale" price. Certain items need to be marked up 50% others 40% and
others 75%. All groups are together in the colum so for instance cells 1-280
need to be marked up 50%, cells 281-900 need to be marked up 40%, and cells
901-3400 need to be marked up 75% and so on. How can I highlight the cells
and do a simple mark up without having to get a calculator out and
calculating what $2 plus 50% mark up is or $15.75 plus 40% mark up is
manually?

"autiemomtoo" wrote:
if it is supposed to be 100% mark up or 110% mark
up what is it multiplied by? would 110% be 2.1?

Right. If it is easier for you, you can write the formula =1+110% in the
helper cell instead of the constant 2.1. Then you edit the percentage figure
directly.

Note: For mark-down, you would enter the formula =1-10%, for example.


----- original message -----

"autiemomtoo" wrote:

yes! thank you so much.... if it is supposed to be 100% mark up or 110% mark
up what is it multiplied by? would 110% be 2.1?

"Mike H" wrote:

Hi,

The answer is the same. say we have these values in a1 to a5

2
3
4.8
8.2
5

I put 1.4 in another cell and copy it. Select these numbers and right
click|Paste special|Multiply Ok, the numbers become

2.8
4.2
6.72
11.48
7

i,e all have been marked up by 40%
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"autiemomtoo" wrote:

Ok maybe I kind of didn't make it clear, sorry. for instance cells 1-208
have all different numbers 2, 15.25, 18., 5, 3, 3.75, 6, 19.99, 22.25, 2.5,
2.75) each number represents a price and each of these prices have to be
marked up by let's say 40%. Not all of the cells are $2.00. the 208 cells
have 208 different prices that need to be marked up 40%. Then cells 209-500
in that colum have all different prices that need to be marked up 75%. So
whatever is in that cell needs to be "plus" whatever percent i need it to be.
I have no idea how to highlight 208 cells of all different prices and make
excel say "add 40%".

"Mike H" wrote:

Hi,

Do it in several steps and for the first markup of 50% try this. Put 1.5 in
a cell and copy it. Select rows 1 to 208 and right click them, click 'paste
Special' select 'Multiply' and then OK.

Repeat for other markups
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"autiemomtoo" wrote:

I have no idea how to do this or if it's possible but I've been at this for
hours and am at a loss. I have 15,000 cells in one column that all have to
have different percentage mark ups. For instance the entire column is a
"wholesale" price. Certain items need to be marked up 50% others 40% and
others 75%. All groups are together in the colum so for instance cells 1-280
need to be marked up 50%, cells 281-900 need to be marked up 40%, and cells
901-3400 need to be marked up 75% and so on. How can I highlight the cells
and do a simple mark up without having to get a calculator out and
calculating what $2 plus 50% mark up is or $15.75 plus 40% mark up is
manually?