16
Jul
Jul
I’ve a price list on Excel for my business. Is there a way I have the ability to increase every number by 10% without doing it manually one by one?
Answer:
Ok, this is what I would do. Let's say you’ve all of your pricing listed down Column A, In Column B type in 1.1, Now go to the cell below and type in 1.1 again. Now activate both 1.1 cells. and drag to the bottom. You will now have 1.1 in all B cells.
Now in C cell type =A1*B1, now drag that to the bottom. You will have all your answers in the C cell.
Book Mark it-> del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Netscape | Yahoo | BlinkList
This entry was posted
on Wednesday, July 16th, 2008 at 3:12 pm and is filed under Software.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or TrackBack URI from your own site.