add percent plus quantity

  • Thread starter Thread starter israel
  • Start date Start date
I

israel

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
 
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.
 
Hi,

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

=1.2*A1*B1
 
Back
Top