add percent plus quantity israel 12/31/2008 9:02:01 PM 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

Re: add percent plus quantity JBeaucaire <JBeaucaire.3laxhy[ at ]thecodecage.com> 12/31/2008 9:16:45 PM 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/showthread.php?t=45603

RE: add percent plus quantity JLatham 12/31/2008 9:22:04 PM 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: [Quoted Text] > 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

Re: add percent plus quantity israel 12/31/2008 9:38:09 PM It works beautiful Thanx -- smile "JBeaucaire" wrote: [Quoted Text] > > 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/showthread.php?t=45603 > >

RE: add percent plus quantity israel 12/31/2008 9:39:01 PM It works both ways and I thank you again -- smile "JLatham" wrote: [Quoted Text] > 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