Formula
I have an extensive price list with my buy prices. I need to add a plus 7%
margin to the final purchase figure. Could someone give me an answer please. |
Formula
Either create an extra column and use
=A2*1.07 where A2 holds the value that you want to add the 7% to, copy down as long as needed or put 1.07 in an empty cell formatted as currency, then copy it, select all values and do editpaste special and select multiply Regards, Peo Sjoblom walr wrote: I have an extensive price list with my buy prices. I need to add a plus 7% margin to the final purchase figure. Could someone give me an answer please. |
Formula
To add 7% to all prices..........
enter 1.07 in an unused cell. Copy then select your price list. EditPaste Special(in place)MultiplyOKEsc. Clear the cell with 1.07 Gord Dibben MS Excel MVP On Fri, 5 Jan 2007 14:21:00 -0800, walr wrote: I have an extensive price list with my buy prices. I need to add a plus 7% margin to the final purchase figure. Could someone give me an answer please. |
All times are GMT +1. The time now is 06:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com