i am trying to increas the price of a product by 10% but i am stuck could you please help
M m azad Sep 25, 2004 #1 i am trying to increas the price of a product by 10% but i am stuck could you please help
N Nick Hodge Sep 25, 2004 #2 Either: If the price in in A1 then in B1 perhaps, type =A1*1.1 or Type 1.1 in a cell, copy it and select the old prices, then Edit>paste special...Values and multiply -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected]
Either: If the price in in A1 then in B1 perhaps, type =A1*1.1 or Type 1.1 in a cell, copy it and select the old prices, then Edit>paste special...Values and multiply -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected]
F Frank Kabel Sep 25, 2004 #3 Hi put 1.1 in an empty cell and copy this cell. then select your price data and goto 'Edit - Paste Special'. choose 'Multiply'
Hi put 1.1 in an empty cell and copy this cell. then select your price data and goto 'Edit - Paste Special'. choose 'Multiply'