Previous Topic Next Topic

Calculating percentage from one column

Solved/Closed
Judy - Jun 17, 2010 at 02:03 PM
 Judy - Jun 17, 2010 at 09:10 PM
Hello,


I am trying to calculate the simple sales commission. I entered the sales amount starting C8 and will continue below. Starting D8, I need to get 10 % of C8 Data.
Not only for C8... C9...C10..............fore every rows


1 response

Answer 1 / 1
Netscur Posts 21 Registration date Thursday July 23, 2009 Status Member Last seen April 6, 2012
Jun 17, 2010 at 02:15 PM
Do you have a maximum range (end column)?

=SUM(C8:C1000)*0.1
0
Judy
Jun 17, 2010 at 02:49 PM
This is not working. I am sorry that I cant explain it right.
I have numbers entered on C8, C9, C10......................(It doesn't have maximum range).
I want to get 10% of C8, C9, C10...... goes on to D8, D9, D10.........
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 17, 2010 at 05:32 PM
Have you tried in D8

= C8 * 0.1
Just enter that in D8 and then drag it down to last row of your data
0
Judy
Jun 17, 2010 at 09:10 PM
THANK YOU
0

Similar discussions

Percentage Work
Winndixie -
RayH -

6 responses
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response