View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Morefeus Direct
 
Posts: n/a
Default how to add a % to amounts in excel

hey billy, still can't get it is there a better way or explain this for newbe's

"BillyRogers" wrote:

enter in cell b2 =a1*1.15 (for a 15% increase)
and copy the cell all the way down to row 1000. You can click on the cell
after entering the formula and then click and hold on the little black square
in the lower right hand corner of the highlighted cell and pull the mouse
cursor all the way down to row 1000 to copy the formula.

--
Billy Rogers

Dallas,TX

Currently Using Office 2000


"Morefeus Direct" wrote:

i have the stadard excel worksheet up , now in line A i have prices all the
way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
to each of these price value, with out having to do one at a time , how do i
do this?