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

Calculating percentage from one column
How to calculate 90 days from date in excel - Guide
Excel copy column from one sheet to another automatically - Guide
Display two columns in data validation list but return only one - Guide
Auto serial number in excel based on another column ✓ - Excel Forum
Formula for calculating position in excel - Excel Forum

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

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.........

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

Judy
Jun 17, 2010 at 09:10 PM

THANK YOU

Similar discussions

Percentage calculation

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

HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS

Calculator percentage

VBA find column by name and sort

Similar discussions

Subscribe To Our Newsletter!