Wednesday, February 8, 2012

How do i calculate the percentage of a column of numbers to another column?

I want to take 40% of Column A's #'s and put in Column BHow do i calculate the percentage of a column of numbers to another column?
Assuming B1 is the first cell to show the percentage, enter this formula in B1:



=A1*.4



Fill the formula down column B.

No comments:

Post a Comment