calculating percentages for columns

W

wilma

Hi,
I am not that good with excel and as I don't have the
book with me can you help? I want to calculate in column
B 30% of the totals in each cell of column a. Can you let
me know what the forula is please? Thanks!
 
T

Tim Otero

Hi Wilma,

Start in B1 with this:

=A1*.30

Hit "Enter." Next, click B1 (to make it the active cell). Move your cursor
to the lower right hand corner of B1, until you see a "+", left click with
your mouse and hold down the button. Drag the cursor down until it is next
to the last cell in A which has values in it. Let go of your mouse button.

Let us know if you have any other questions.

tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Weeks 0
Calculate the median value before a specified list 0
Get percentage of whole 2
Percentage Increase 11
Needs help combining functions. 3
Simple (maybe) percentage forumla 5
Help with lots of formulas 3
Excel does not accept text format! 0

Top