View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Israel Israel is offline
external usenet poster
 
Posts: 47
Default add percent plus quantity

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