Hi,

Before I begin I must relay my sincere thanks to this site as it is very
helpful in situations where there are too few knowledgeable answers.

This time my problem to solve is as follows;

I have a cell (200 rows) with an amount, I have to add 20% plus I have to
add quantity. How do I write a formula for this.
Example:
column A row 1 "3" (for quantity)
column B row 1 "$25.00 (amount)
Now I would like to add 20% to $25 plus the quantity. The spreadsheet
contains
200 rows.

Thank you
Happy New Year
--
smile

A1 = 3 (Qty)
B1 = $25 (price)

20% = markup

C1 =(B1*1.2)*A1


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45603

If I have a proper picture of this, then this formula in column C, row 1,
should do the job:
=A1 * (1.2 * B1)
a more complex form of that formula, but perhaps clearer in meaning would be:
=A1 * (B1 + (.2 * B1))
Fill the formula down through all 200 rows and your answers will be in
column C.

A quick way to fill them is to select cell C1, with the new formula in it,
and then move the cursor to the lower right corner of that cell until it
becomes a small + symbol and then double-click: the formula will be filled
down the sheet to the end of the list in column B.



"israel" wrote:

Hi,

Before I begin I must relay my sincere thanks to this site as it is very
helpful in situations where there are too few knowledgeable answers.

This time my problem to solve is as follows;

I have a cell (200 rows) with an amount, I have to add 20% plus I have to
add quantity. How do I write a formula for this.
Example:
column A row 1 "3" (for quantity)
column B row 1 "$25.00 (amount)
Now I would like to add 20% to $25 plus the quantity. The spreadsheet
contains
200 rows.

Thank you
Happy New Year
--
smile

It works beautiful
Thanx
--
smile


"JBeaucaire" wrote:


A1 = 3 (Qty)
B1 = $25 (price)

20% = markup

C1 =(B1*1.2)*A1


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45603

It works both ways and I thank you again


--
smile


"JLatham" wrote:

If I have a proper picture of this, then this formula in column C, row 1,
should do the job:
=A1 * (1.2 * B1)
a more complex form of that formula, but perhaps clearer in meaning would be:
=A1 * (B1 + (.2 * B1))
Fill the formula down through all 200 rows and your answers will be in
column C.

A quick way to fill them is to select cell C1, with the new formula in it,
and then move the cursor to the lower right corner of that cell until it
becomes a small + symbol and then double-click: the formula will be filled
down the sheet to the end of the list in column B.



"israel" wrote:

Hi,

Before I begin I must relay my sincere thanks to this site as it is very
helpful in situations where there are too few knowledgeable answers.

This time my problem to solve is as follows;

I have a cell (200 rows) with an amount, I have to add 20% plus I have to
add quantity. How do I write a formula for this.
Example:
column A row 1 "3" (for quantity)
column B row 1 "$25.00 (amount)
Now I would like to add 20% to $25 plus the quantity. The spreadsheet
contains
200 rows.

Thank you
Happy New Year
--
smile

Hi,

Multiplication is destributive which means you can simplify the formula to
read

=1.2*A1*B1

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"israel" wrote:

It works both ways and I thank you again


--
smile


"JLatham" wrote:

If I have a proper picture of this, then this formula in column C, row 1,
should do the job:
=A1 * (1.2 * B1)
a more complex form of that formula, but perhaps clearer in meaning would be:
=A1 * (B1 + (.2 * B1))
Fill the formula down through all 200 rows and your answers will be in
column C.

A quick way to fill them is to select cell C1, with the new formula in it,
and then move the cursor to the lower right corner of that cell until it
becomes a small + symbol and then double-click: the formula will be filled
down the sheet to the end of the list in column B.



"israel" wrote:

Hi,

Before I begin I must relay my sincere thanks to this site as it is very
helpful in situations where there are too few knowledgeable answers.

This time my problem to solve is as follows;

I have a cell (200 rows) with an amount, I have to add 20% plus I have to
add quantity. How do I write a formula for this.
Example:
column A row 1 "3" (for quantity)
column B row 1 "$25.00 (amount)
Now I would like to add 20% to $25 plus the quantity. The spreadsheet
contains
200 rows.

Thank you
Happy New Year
--
smile