datafeeds and formulas

  • Thread starter Dchaney Indianapolis
  • Start date
D

Dchaney Indianapolis

hi i need to change the prices in my datafeed to show an increase in price of
20% in the price colum for example if an item cost $20.00 dollers i want
to beabel to change it to show a 20% increase in price to say $20.80. id
like it to do this from line one all the way to the bottom of the
spreadsheet. row 19,890
 
G

Guest

Hi
Assuming your existing price is in A7, try this in A8:
=A7*1.2
Once you have done that, reselect the cell and double-click on the little
black square in the bottom right-hand corner of that cell to automatically
fill down the series.
By the way, a 20% increase on $20 is not $20.80!
 
D

Dchaney Indianapolis

the finished price was only a example not really the correct price it would
be but thanks you did answer my question .
 
G

Guest

Thanks for the feedback!

--
Andy.


Dchaney Indianapolis said:
the finished price was only a example not really the correct price it
would
be but thanks you did answer my question .
Click to expand...
 
L

Lady Layla

EAsiest way -- if you do not need to capture it in a separate column., In an
empty cell type 1.2,Select the cell, Edit -- Copy, Select the cells you want
changed, Edit -- Paste Special -- Multiply OKAY


message : hi i need to change the prices in my datafeed to show an increase in price of
: 20% in the price colum for example if an item cost $20.00 dollers i want
: to beabel to change it to show a 20% increase in price to say $20.80. id
: like it to do this from line one all the way to the bottom of the
: spreadsheet. row 19,890
 
Top